Greg Smith wrote: > On Thu, 5 Jun 2008, Magnus Hagander wrote: > >> We really need a "proper API" for it, and the stuff in pgAdmin isn't >> even enough to base one on. > > I would be curious to hear your opinion on whether the GUC overhaul > discussed in this thread is a useful precursor to building such a proper > API.
I'm getting back to this one now that the discussion has died down a bit. As usual, the discussion spread out into these huge changes needed to be done to satisfy everyone from day one. I don't think that's the way to go - we have to do it piece by piece if that's ever going to be done. IMHO the first thing to do is to create a stable API for modifying config variables remotely. *at this time* it doesn't matter how this API modifies the configuration, if it's in a file on in the db or whatever. We can always change that later... Which is why I will be proceeding with this one - make an API that requires the least possible change for now, per discussions earlier this year (not in this thread) :-) Now, this in itself is unrelated to the stuff Josh was talking about which is collecting the information in one place and being able to generate config files that don't contain everything, and being able to auto-tune things. It would be nice for such a tool to be able to get the full descriptions and such from the pg_settings view or such, which means it needs to go in the code and not in a standalone file, but it's not *as necessary*. I still think the config file we ship today is horrible, I get lots of questions around it, and I see lots of examples of people who tweak settings they have no idea what they do, just because it's there. That's a separate issue that could *either* be solved by shipping more than one default config file, or it could be solved by the config file generator Josh proposed. //Magnus -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
