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

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Justin Clift <jclift@iprimus.com.au>
Cc: pgsql-hackers@postgresql.org
Date: 2001-04-09T17:44:40Z
Lists: pgsql-hackers
> 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, Pennsylvania 19026