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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: AW: AW: [HACKERS] Some notes on optimizer cost estimates
Дата
Msg-id 200001280338.WAA06875@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: AW: AW: [HACKERS] Some notes on optimizer cost estimates  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
[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@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
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] [6.5.3] 'attribute not found'
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Re: ORDBMS