Re: AW: AW: [HACKERS] Some notes on optimizer cost estimates

[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> On 2000-01-26, Tom Lane mentioned:
>
> > BTW, I have been thinking that it'd be a lot better if these flags could
> > be twiddled via SET/SHOW commands, instead of having to restart psql.
> > Nothing done about it yet, but it's an idea...
> >
> > Also, you already can twiddle the basic cost parameters (cpu_page_weight
> > and cpu_index_page_weight) via SET variables whose names I forget at the
> > moment. There will be probably be at least one more such variable
> > before 7.0 comes out, to control cost of random page fetch vs. sequential.
>
> Independent of this, I thought numerous times (when similar "tuning"
> issues came up) that it's time for a real unified configuration file,
> which includes pg_options, the geqo what-not, an option for each of these
> backend tuning options (join methods, fsync), heck maybe even the port
> number and an alternative location for temp/sort files. Kind of put all
> the administration in one place. Something to think about maybe.

Added to TODO:

* Unify configuration into one configuration file

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026