pg.ddx.io pgsql-performance@postgresql.org mailing list archivehelp / color / mirror / Atom feed
tweaking under repeatable load 2+ messages / 2 participants [nested] [flat]
* tweaking under repeatable load @ 2007-01-07 19:03 Ben <bench@silentmedia.com> 0 siblings, 1 reply; 2+ messages in thread From: Ben @ 2007-01-07 19:03 UTC (permalink / raw) To: 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? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: tweaking under repeatable load @ 2007-01-08 09:18 Dimitri Fontaine <dim@dalibo.com> parent: Ben <bench@silentmedia.com> 0 siblings, 0 replies; 2+ messages in thread From: Dimitri Fontaine @ 2007-01-08 09:18 UTC (permalink / raw) To: pgsql-performance; +Cc: Ben <bench@silentmedia.com> Le dimanche 7 janvier 2007 20:03, Ben a écrit : > 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. [...] > > Has anybody done anything similar to this? Anything better? Did it > end up being a waste of time, or was it helpful? Please have a look at this: http://pgfouine.projects.postgresql.org/tsung.html -- Dimitri Fontaine http://www.dalibo.com/ ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-01-08 09:18 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-01-07 19:03 tweaking under repeatable load Ben <bench@silentmedia.com> 2007-01-08 09:18 ` Dimitri Fontaine <dim@dalibo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox