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 VAA31069 for ; Tue, 9 Mar 1999 21:50:28 -0500 (EST) (envelope-from karl@Genesis.Denninger.Net) Received: (from karl@localhost) by Genesis.Denninger.Net (8.9.3/8.8.2) id UAA16787; Tue, 9 Mar 1999 20:50:18 -0600 (CST) Message-ID: <19990309205018.A16780@Denninger.Net> Date: Tue, 9 Mar 1999 20:50:18 -0600 From: Karl Denninger To: Clark Evans , Tim Perdue Cc: pgsql-sql@hub.org Subject: Re: [SQL] Performance References: <001701be6a95$f0aeee20$0b8c5aa5@timnt.weather.net> <36E5D919.15D11C54@manhattanproject.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.93.2i In-Reply-To: <36E5D919.15D11C54@manhattanproject.com>; from Clark Evans on Wed, Mar 10, 1999 at 02:29:45AM +0000 Organization: Karl's Sushi and Packet Smashers X-Die-Spammers: Spammers will be LARTed and the remains fed to my cat On Wed, Mar 10, 1999 at 02:29:45AM +0000, Clark Evans wrote: > Tim Perdue wrote: > > BELIEVE IT OR NOT, PostgreSQL is handling 1.8GB in just one table, and its > > performance is amazing. I have archived 1,100,000 emails in the database and > > I don't really see much slowdown yet. > > What is your hardware, os, etc? > > Thanks! > > Clark Evans I have had tables exceeding 10GB in one dataset, and the performance wa STILL excellent. Hardware was a Pentium Pro 200, FreeBSD, and a CMD RAID controller. -- -- 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.