On Sat, Dec 7, 2013 at 3:28 AM, Álvaro Hernández Tortosa <aht@nosys.es> wrote:
>>> "Right now, writing such a tool in a generic way gets so bogged down
>>> just in parsing/manipulating the postgresql.conf file that it's hard to
>>> focus on actually doing the tuning part."
>>
>> That was in 2008. I don't think that stance is accurate anymore.
>
> Just for me to learn about this: why is it not accurate anymore?
This topic has been under active discussion for the last five years. I
strongly recommend going back and skimming over the past discussions
before trying to pick it up again. In particular go look up the
discussion of SET PERSISTENT
Since we have include files now you can just generate an
auto-tune.conf and not try to parse or write the main config file.
The reason previous efforts got bogged down in parsing/manipulating
the postgresql.conf file was purely because they were trying to allow
you to edit the file by hand and mix that with auto generated config.