From: | "vincent" <vinny(at)xs4all(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: looking for some real world performance numbers |
Date: | 2007-10-22 11:33:54 |
Message-ID: | 15275.84.107.170.210.1193052834.squirrel@webmail.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moran | 2007-10-22 12:20:36 | Re: Indexes & Primary Keys (based on the same columns) |
Previous Message | Michael Fuhr | 2007-10-22 11:07:14 | Re: looking for some real world performance numbers |