pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tim Perdue <perdue@raccoon.com>
To: pgsql-sql@hub.org
Subject: Performance
Date: Tue, 9 Mar 1999 19:33:02 -0600
Message-ID: <001701be6a95$f0aeee20$0b8c5aa5@timnt.weather.net> (raw)

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




view thread (19+ messages)  latest in thread

Message-ID: <001701be6a95$f0aeee20$0b8c5aa5@timnt.weather.net>
Permalink:  ../001701be6a95$f0aeee20$0b8c5aa5@timnt.weather.net/
Also on:    postgresql.org/message-id/001701be6a95$f0aeee20$0b8c5aa5@timnt.weather.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: perdue@raccoon.com, pgsql-sql@hub.org
  Subject: Re: Performance
  In-Reply-To: <001701be6a95$f0aeee20$0b8c5aa5@timnt.weather.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox