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