Received: from Genesis.Denninger.Net (kdhome-2.pr.mcs.net [205.164.6.10]) by hub.org (8.9.2/8.9.1) with ESMTP id PAA64312 for ; Sat, 13 Mar 1999 15:17:53 -0500 (EST) (envelope-from karl@Genesis.Denninger.Net) Received: (from karl@localhost) by Genesis.Denninger.Net (8.9.3/8.8.2) id OAA00909; Sat, 13 Mar 1999 14:17:39 -0600 (CST) Message-ID: <19990313141739.A905@Denninger.Net> Date: Sat, 13 Mar 1999 14:17:39 -0600 From: Karl Denninger To: "Brett W. McCoy" Cc: Tim Perdue , pgsql-sql@hub.org Subject: Re: [SQL] So what happens at 2GB? References: <19990312175655.A981@Denninger.Net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.93.2i In-Reply-To: ; from Brett W. McCoy on Sat, Mar 13, 1999 at 01:11:23PM -0500 Organization: Karl's Sushi and Packet Smashers X-Die-Spammers: Spammers will be LARTed and the remains fed to my cat 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.