table size limit under Linux - Mailing list pgsql-admin

From HENAFF Mari-mai FTRD/DMI/LAN
Subject table size limit under Linux
Date
Msg-id 7D59335FDAE0D011A3350060974B1C7202EBC832@l-mhs3.lannion.cnet.fr
Whole thread Raw
Responses Re: table size limit under Linux  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
List 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.


pgsql-admin by date:

Previous
From: Loïc TREGOUËT
Date:
Subject: pgaccess use wrong password
Next
From: Norbert Meissner
Date:
Subject: Re: table size limit under Linux