Re: looking for some real world performance numbers

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