Received: from slip1.raccoon.com (slip1.raccoon.com [165.90.135.16])
	by hub.org (8.9.2/8.9.1) with ESMTP id UAA22746
	for <pgsql-sql@hub.org>; Tue, 9 Mar 1999 20:34:29 -0500 (EST)
	(envelope-from perdue@raccoon.com)
Received: from timnt (tim.desmoinesnet.com [165.90.140.11])
	by slip1.raccoon.com (8.8.7/8.8.7) with SMTP id TAA08784
	for <pgsql-sql@hub.org>; Tue, 9 Mar 1999 19:32:54 -0600
Message-ID: <001701be6a95$f0aeee20$0b8c5aa5@timnt.weather.net>
Reply-To: "Tim Perdue" <perdue@raccoon.com>
From: "Tim Perdue" <perdue@raccoon.com>
To: <pgsql-sql@hub.org>
Subject: Performance
Date: Tue, 9 Mar 1999 19:33:02 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Some time back I sent out a message asking if PGSQL would be able to handle
my mailing list archive at http://www.geocrawler.com/ , and whether it would
scale up to 100MB.

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.

I'm just stunned at how well this is working, and I keep pushing myself to
find more and more mail archives to add to my database.

It's fun! Check out the linux/freebsd/etc mail archives at geocrawler.com

Tim