Re: looking for some real world performance numbers

> On Sat, Oct 20, 2007 at 11:11:32PM -0700, snacktime wrote:
>> So what would really help me is some real world numbers on how
>> postgresql is doing in the wild under pressure.  If anyone cares to
>> throw some out I would really appreciate it.
>
> 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.
>
> --
> Michael Fuhr
>


What kind of hardware are you using for this system? Just to get an idea
of what 'decent hardware' is in this case.

regards,
vincent.