Thread: So what happens at 2GB?
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
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 > >
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------
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.
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------