Skip site navigation (1) Skip section navigation (2)

Re: table size limit under Linux

From: Norbert Meissner <norbert(dot)meissner(at)str(dot)daimler-benz(dot)com>
To: HENAFF Mari-mai FTRD/DMI/LAN <marimai(dot)henaff(at)rd(dot)francetelecom(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: table size limit under Linux
Date: 2000-05-31 11:37:45
Message-ID: 3934F989.15BCDFE7@syssun11f.rrz.debis.str.daimler-benz.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.


In response to

Responses

pgsql-admin by date

Next:From: Wallingford, TedDate: 2000-05-31 12:45:55
Subject: create view security
Previous:From: Peter EisentrautDate: 2000-05-31 11:31:09
Subject: Re: table size limit under Linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group