On Mon, Oct 22, 2007 at 01:33:54PM +0200, vincent wrote:
> > One of my databases has about 70M rows inserted, 30M rows updated,
> > 70M rows deleted, and 3G rows retrieved per day. At peak times of
> > the day it sustains around 120K rows/minute inserted, 80K rows/minute
> > updated or deleted, and 3.5M rows/minute retrieved and it has room
> > to grow. Usage patterns are different than for a web application,
> > however: transaction rates are low (a few hundred per minute) and
> > most logic is in database functions with statements that operate
> > on hundreds or thousands of rows at a time. Still, this gives an
> > idea of what a PostgreSQL database on decent hardware can handle.
>
> What kind of hardware are you using for this system? Just to get an idea
> of what 'decent hardware' is in this case.
I don't know the full specs because another group is responsible
for that. I think the box has four Athlon 64 X2s with 32G RAM. At
least some of the storage is SAN-attached.
--
Michael Fuhr