> 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