Would it be worth first agreeing on a common set of criteria to
measure? I see many data points going back and forth but not much
agreement on what's worth measuring and how to measure.
I'm not necessarily trying to herd cats, but it sure would be swell to
have the several knowledgeable minds here come up with something that
could uniformly tested on a range of machines, possibly even integrated
into pg_bench or something. Disagreements on criteria or methodology
should be methodically testable.
Then I have dreams of a new pg_autotune that would know about these
kinds of system-level settings.
I haven't been on this list for long, and only using postgres for a
handful of years, so forgive it if this has been hashed out before.
-Bill
-----
Bill McGonigle, Owner Work: 603.448.4440
BFC Computing, LLC Home: 603.448.1668
bill@xxxxxxxxxxxxxxxx Mobile: 603.252.2606
http://www.bfccomputing.com/ Pager: 603.442.1833
Jabber: flowerpt@xxxxxxxxx Text: bill+text@xxxxxxxxxxxxxxxx
Blog: http://blog.bfccomputing.com/
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings