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