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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
