Performance suggestions for an update-mostly database?

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Performance suggestions for an update-mostly database?
Date: 2004-10-04 17:40:19
Message-ID: 20041004174019.GA25671@gp.word-to-the-wise.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'm putting together a system where the operation mix is likely to be
>95% update, <5% select on primary key.

I'm used to performance tuning on a select-heavy database, but this
will have a very different impact on the system. Does anyone have any
experience with an update heavy system, and have any performance hints
or hardware suggestions?

Cheers,
Steve

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Steve Atkins 2004-10-04 18:00:36 Re: Performance suggestions for an update-mostly database?
Previous Message Josh Berkus 2004-10-04 17:38:14 Re: Performance suggestions for an update-mostly database?