Re: Re: Maximum size of one table

From: "Jonas Lindholm" <jonas(dot)lindholm(at)omgroup(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Maximum size of one table
Date: 2001-03-14 20:07:35
Message-ID: 98oj6g$1f8$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks, good news.

I'm also pleased to know that the file size limit has been removed with LFS
on Linux 2.4 and I'll give it a try.

/Jonas L.

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:25370(dot)984585704(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> jdassen(at)cistron(dot)nl (J.H.M. Dassen (Ray)) writes:
> > Your options to have >2Gb files on GNU/Linux therefore include
> > - switching to a 64bit platform, say Alpha, Itanic or PowerPC64 or
> > - switching to a recent (>= 2.1) version of the GNU C library and a
recent
> > (e.g. 2.4.x) kernel.
>
> However, this is all irrelevant to Jonas' question, which is whether
> he needs to worry about it for Postgres. He doesn't. PG splits large
> tables into gigabyte-sized chunks to avoid OS file size limitations.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Ploski 2001-03-14 20:09:33 Compiling 7.1 JDBC driver
Previous Message Richard H 2001-03-14 20:02:35 Re: Case Insensitive CHECK CONSTRAINTs