Re: table size limit under Linux

Hi Mari,

as far as i know is the table size limited through the size of int4 (=size of
oid, 32 Bits). This means that you can have an amount 4 "Gigarows" in one table.

There are some people working on the 2 GB Limitation on the Linux filesystem. I
remember an article about this in a german computer magazine. It seems that they
will break the barrier in autumn. In the moment you have to patch many things in
the system to get filesizes over 2 GB and no one will guarantee that it will
work stable then.

If you aren't bound to linux, you can use FreeBSD, another free *ix OS. It has a
maximum filesize of 2 TB and it is even more stable than linux. Of course it
will run PostgreSQL too ;-)

Norbert

HENAFF Mari-mai FTRD/DMI/LAN schrieb:

> 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.