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@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden