Re: Re: Maximum size of one table - Mailing list pgsql-general

From Jonas Lindholm
Subject Re: Re: Maximum size of one table
Date
Msg-id 98oj6g$1f8$1@news.tht.net
Whole thread Raw
In response to Re: Re: Maximum size of one table  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@sss.pgh.pa.us> wrote in message
news:25370.984585704@sss.pgh.pa.us...
> jdassen@cistron.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@postgresql.org



pgsql-general by date:

Previous
From: "Jêdrzej Karabasz"
Date:
Subject: no response from backend
Next
From: Richard H
Date:
Subject: Re: Fast Inserts and Hardware Questions