From: Karl Denninger <karl@Denninger.Net>
To: Brett W. McCoy <bmccoy@lan2wan.com>
Cc: Tim Perdue <perdue@raccoon.com>
Cc: pgsql-sql@hub.org
Subject: Re: [SQL] So what happens at 2GB?
Date: Sat, 13 Mar 1999 14:17:39 -0600
Message-ID: <19990313141739.A905@Denninger.Net> (raw)
In-Reply-To: <Pine.LNX.4.04.9903131310590.4823-100000@dragosani.lan2wan.com>
References: <19990312175655.A981@Denninger.Net>
<Pine.LNX.4.04.9903131310590.4823-100000@dragosani.lan2wan.com>
On Sat, Mar 13, 1999 at 01:11:23PM -0500, Brett W. McCoy wrote:
> On Fri, 12 Mar 1999, Karl Denninger wrote:
>
> > No. It works properly. I have had tables exceeding 10GB.
>
> How does it get past an operating system limitation on file size?
>
> Brett W. McCoy
> http://www.lan2wan.com/~bmccoy/
There isn't one on FreeBSD, but Postgres doesn't seem to know that.
Instead, it breaks the table up into 2G-sized file chunks.
--
--
Karl Denninger (karl@denninger.net) http://www.mcs.net/~karl
I ain't even *authorized* to speak for anyone other than myself, so give
up now on trying to associate my words with any particular organization.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: karl@Denninger.Net, bmccoy@lan2wan.com, perdue@raccoon.com, pgsql-sql@hub.org
Subject: Re: [SQL] So what happens at 2GB?
In-Reply-To: <19990313141739.A905@Denninger.Net>
References: <19990312175655.A981@Denninger.Net> <Pine.LNX.4.04.9903131310590.4823-100000@dragosani.lan2wan.com> <19990313141739.A905@Denninger.Net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox