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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
