Re: improvements to pgtune - Mailing list pgsql-hackers

From Joshua Berkus
Subject Re: improvements to pgtune
Date
Msg-id 1388469010.173794.1303964311479.JavaMail.root@mail-1.01.com
Whole thread Raw
In response to Re: improvements to pgtune  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-hackers
> Every time I've gotten pulled into discussions of setting parameters 
> based on live monitoring, it's turned into a giant black hole--absorbs a 
> lot of energy, nothing useful escapes from it.  I credit completely 
> ignoring that idea altogether, and using the simplest possible static 
> settings instead, as one reason I managed to ship code here that people 
> find useful.  I'm not closed to the idea, just not optimistic it will 
> lead anywhere useful.  That makes it hard to work on when there are so 
> many obvious things guaranteed to improve the program that could be done 
> instead.

What would you list as the main things pgtune doesn't cover right now?  I have my own list, but I suspect that yours is
somewhatdifferent.
 

I do think that autotuning based on interrogating the database is possible.  However, I think the way to make it not be
atar baby is to tackle it one setting at a time, and start with ones we have the most information for.  One of the real
challengesthere is that some data can be gleaned from pg_* views, but a *lot* of useful performance data only shows up
inthe activity log, and then only if certain settings are enabled.
 

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: unknown conversion %m
Next
From: Sim Zacks
Date:
Subject: Re: Proposal - asynchronous functions