From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
---|---|
To: | Karl Denninger <karl(at)Denninger(dot)Net> |
Cc: | Tim Perdue <perdue(at)raccoon(dot)com>, pgsql-sql(at)hub(dot)org |
Subject: | Re: [SQL] So what happens at 2GB? |
Date: | 1999-03-13 20:30:43 |
Message-ID: | Pine.LNX.4.04.9903131529440.4823-100000@dragosani.lan2wan.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Sat, 13 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.
It may do that for performance reasons, I would guess, or for
compatibility with other operating systems that have the limitation (like
Linux).
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
We are what we pretend to be.
-- Kurt Vonnegut, Jr.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N+ o K- w--- O@ M@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ G++ e>++ h+(---) r++ y++++
------END GEEK CODE BLOCK------
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Perdue | 1999-03-14 04:46:49 | URGENT - "CANNOT EXTEND" |
Previous Message | Karl Denninger | 1999-03-13 20:17:39 | Re: [SQL] So what happens at 2GB? |