Horton

Thread

  1. So what happens at 2GB?

    Tim Perdue <perdue@raccoon.com> — 1999-03-12T23:35:17Z

    I'm told that my postgres table will automagically split when it hits 2GB,
but I understand that code is not well tested.

Do I need to worry at all when I hit 2GB?

Thanks,

Tim
geocrawler

  2. Re: [SQL] So what happens at 2GB?

    Karl Denninger <karl@denninger.net> — 1999-03-12T23:56:55Z

    No.  It works properly.  I have had tables exceeding 10GB.

--
-- 
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.


On Fri, Mar 12, 1999 at 05:35:17PM -0600, Tim Perdue wrote:
> I'm told that my postgres table will automagically split when it hits 2GB,
> but I understand that code is not well tested.
> 
> Do I need to worry at all when I hit 2GB?
> 
> Thanks,
> 
> Tim
> geocrawler
> 
>

  3. Re: [SQL] So what happens at 2GB?

    Brett W. McCoy <bmccoy@lan2wan.com> — 1999-03-13T18:11:23Z

    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/
-----------------------------------------------------------------------
If you float on instinct alone, how can you calculate the buoyancy for
the computed load?
		-- Christopher Hodder-Williams

-----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------

  4. Re: [SQL] So what happens at 2GB?

    Karl Denninger <karl@denninger.net> — 1999-03-13T20:17:39Z

    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.

  5. Re: [SQL] So what happens at 2GB?

    Brett W. McCoy <bmccoy@lan2wan.com> — 1999-03-13T20:30:43Z

    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------