Re: "--tuning" compile and runtime option (?)

> Hi Bruce,
> 
> My thought on this is more for an "overall effect".
> 
> Down The Track (i.e. in a few versions or so) I'm thinking, rightly or
> wrongly, that PostgreSQL will become Very Good at tuning itself.
> 
> It would be a good thing if PostgreSQL could know just how fair it can
> play in regards to the server it's working on.

OK, what options would you recommend be auto-tuned in each circumstance?
I can imagine open files and maybe sortmemory, but even then, other
backends can affect the proper value.  Share memory usually has a kernel
limit which prevents us from auto-tuning that too much.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026