| From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
|---|---|
| To: | HENAFF Mari-mai FTRD/DMI/LAN <marimai(dot)henaff(at)rd(dot)francetelecom(dot)fr> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: table size limit under Linux |
| Date: | 2000-05-31 11:31:09 |
| Message-ID: | Pine.GSO.4.02A.10005311329150.698-100000@Gepard.DoCS.UU.SE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 31 May 2000, HENAFF Mari-mai FTRD/DMI/LAN wrote:
> 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.
The table will be split into two (or more) files at gigabyte boundaries.
> 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).
Because the segment size is 1 gigabyte, this can't really be related.
Giving more details on "failure" might help though.
--
Peter Eisentraut Sernanders väg 10:115
peter_e(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Norbert Meissner | 2000-05-31 11:37:45 | Re: table size limit under Linux |
| Previous Message | Peter Eisentraut | 2000-05-31 11:28:47 | Re: pgaccess use wrong password |