Re: table size limit under Linux

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