> 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.