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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026