Performance - Mailing list pgsql-sql

From Tim Perdue
Subject Performance
Date
Msg-id 001701be6a95$f0aeee20$0b8c5aa5@timnt.weather.net
Whole thread Raw
Responses Re: [SQL] Performance  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
Re: [SQL] Performance  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [SQL] How to optimize a query...
Next
From: Clark Evans
Date:
Subject: Re: [SQL] Performance