What's your thought on creating some type of calibration applet that will
divine proper settings for the PostgreSQL performance related variables by
taking into consideration the speed of the machine, amount of RAM, access time
of the filesystem, and the speed of various queries on a standardized (perhaps
non-standardized?) dataset under different conditions?
Is this possible, do-able, or even wanted? Where would one begin constructing
the tests?
I imagine it would automate the tasks that every PostgreSQL administrator goes
through to calibrate his or her installation with the best possible performance
settings...
CG
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com