Tino Wildenhain wrote:
Figuring out the correct values for some of the buffers and costs
is still a bit tough. Otoh, I guess there is no easy way to predict
all these.
pgAdmin has a mechanism to suggest values (currently for autovacuum and
listen_address only), which waits for expansion :-) I could think of a
wizard that asks decent questions, resulting in proposals.
Whether implemented as GUI or not, a questionaire and suggested
algorithms to calculate settings (eyeballed from Core) would be a good
starting point.
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq