| From: | HENAFF Mari-mai FTRD/DMI/LAN <marimai(dot)henaff(at)rd(dot)francetelecom(dot)fr> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | table size limit under Linux |
| Date: | 2000-05-31 10:08:09 |
| Message-ID: | 7D59335FDAE0D011A3350060974B1C7202EBC832@l-mhs3.lannion.cnet.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I read that postgres table size is unlimited.
But, a postgres table is stored into a file, and the size of a file is
limited to approximately 2 Giga Bytes under Linux.
I tried to test this by inserting hundreds of thousands of rows into a table
: my insert queries failed when the file containing the table reached
approximately 2 Giga Bytes (under Linux).
So, it seems that the size of a Postgres table is limited to the maximum
file size under Linux (approximately 2 Giga Bytes).
Can anyone confirm that to me ?
If it is possible to have tables of unlimited size under Linux, can anyone
tell me how to do that ?
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-05-31 11:28:47 | Re: pgaccess use wrong password |
| Previous Message | Loïc TREGOUËT | 2000-05-31 09:52:57 | pgaccess use wrong password |