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 ;-)
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 ?
In response to
pgsql-admin by date
|Next:||From: Wallingford, Ted||Date: 2000-05-31 12:45:55|
|Subject: create view security|
|Previous:||From: Peter Eisentraut||Date: 2000-05-31 11:31:09|
|Subject: Re: table size limit under Linux|