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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Wallingford, Ted | 2000-05-31 12:45:55 | create view security |
Previous Message | Peter Eisentraut | 2000-05-31 11:31:09 | Re: table size limit under Linux |