tweaking under repeatable load

From: Ben <bench(at)silentmedia(dot)com>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: tweaking under repeatable load
Date: 2007-01-07 19:03:50
Message-ID: 1554969B-3526-4E6F-941D-2DF845C77541@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'd like to optimize my postgres configuration for optimal
performance under typical load. Unfortunately, as I understand
things, that implies that I have to have a way to repeat the same
load each time I try out new settings, so that I can fairly compare.
It's difficult for me to drive the load all the way through my
application, so I'm envisioning some script like pqa that analyzes
the logged queries against the database during a typical load period,
and then lets me replay them directly against the database with the
same original frequency.

Has anybody done anything similar to this? Anything better? Did it
end up being a waste of time, or was it helpful?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig A. James 2007-01-07 23:56:31 Re: High update activity, PostgreSQL vs BigDBMS
Previous Message Dave Cramer 2007-01-07 15:29:02 Re: High update activity, PostgreSQL vs BigDBMS