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 ;-)

What PostgreSQL version are you running? We are able to go >2 gigs. I
think some have 10 gig tables, even on Linux. What version are you
using?

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026