I imagined they could run pgtune anytime after install to update those performance parameters. It gives them a one-stop location to at least do minimal tuning, and as their load changes, they can run it again.
--------------------------------------------------------------------------- Daniel Kalchev wrote: > >>>Bruce Momjian said: > [...] > > For example, we can ask them how many rows and tables they will be > > changing, on average, between VACUUM runs. That will allow us set the > > FSM params. We can ask them about using 25% of their RAM for shared > > buffers. If they have other major apps running on the server or have > > small tables, we can make no changes. We can basically ask them > > questions and use that info to set values. > > Bruce, this is an very good idea and such tool would simplify setup for the > me-too type of DBA - we should definitely try to attract them. > > However, how could one possibly answer the above question, if they setup their > database for the first time? > > What is more, these settings are on a per-installation, not per-database - > which means, that if you have several small, but active databases and one > large database the requirements will be very different. > > Nobody likes answering such questions when installing new software. You might > enjoy it the first few times, but then learn the 'answers' and don't even > think what the question is. (we all know the answer :) > > Perhaps indeed a better idea is to have PostgreSQL itself collect usage > statistics, and from time to time print 'suggestions' to the log file (best in > my opinion), or have these available via some query. These suggestions should > best reflect the of course require minimal intervention to the database > system, such as restart etc. > > > Daniel > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
