Обсуждение: Is the max size of a table limited by the max file size of the file system?
If I am right, for every table in a postgres database a file with a certain number is created in the postgres data directory for the according database. So my question is, if the maximum size of a table is limited by the maximum file size of the underlying filesystem (e.g. 2GB for ufs). Or will a new file be created if the limit is reached? Thanks Andreas. ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/
We segment tables in 1gig file chunks, so you are fine. --------------------------------------------------------------------------- u15074 wrote: > If I am right, for every table in a postgres database a file with a certain > number is created in the postgres data directory for the according database. > > So my question is, if the maximum size of a table is limited by the maximum file > size of the underlying filesystem (e.g. 2GB for ufs). Or will a new file be > created if the limit is reached? > > Thanks Andreas. > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
On Thu, 12 Jun 2003, u15074 wrote: > If I am right, for every table in a postgres database a file with a certain > number is created in the postgres data directory for the according database. > > So my question is, if the maximum size of a table is limited by the maximum file > size of the underlying filesystem (e.g. 2GB for ufs). Or will a new file be > created if the limit is reached? Good news, it's not. As of about 7.2, postgresql started splitting all it's datafiles at the 1 gig point. so, you'll have files like this in your base directory: 19283 19283.1 19283.2 as your table grows. Sweet, huh? :-)