From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | vincent <vinny(at)xs4all(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: looking for some real world performance numbers |
Date: | 2007-10-22 14:46:01 |
Message-ID: | 20071022144600.GA11674@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Trevor Talbot | 2007-10-22 15:04:03 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |
Previous Message | Trevor Talbot | 2007-10-22 14:43:35 | Re: 8.2.3: Server crashes on Windows using Eclipse/Junit |