Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
Дата
Msg-id 4332.1055274227@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning  (Vincent van Leeuwen <pgsql.spam@vinz.nl>)
Ответы Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning  (Vincent van Leeuwen <pgsql.spam@vinz.nl>)
Список pgsql-performance
Vincent van Leeuwen <pgsql.spam@vinz.nl> writes:
> Halving the cpu_tuple_cost has given a very impressive performance boost
> (performance roughly doubled). I'm not sure why, because the plans of the
> large queries I was checking haven't changed as far as I can see, but maybe
> some smaller queries I didn't bother to check are using a different plan now.

That's very curious; I'd expect that parameter to have only marginal
effect in the first place (unless you make huge changes in it, of course).
It must have changed some plan that you didn't take note of.  If you can
find it I'd be interested to know.

> Just to be absolutely sure: all *_cost parameters only influence the
> chosen plan, right? There is absolutely nothing else influenced which
> doesn't show up in an EXPLAIN ANALYZE, right?

AFAIR, the only one of these parameters that the executor pays any
attention to is SORT_MEM; that will determine how soon the runtime code
starts to spill tuples to disk in sorts, hash tables, etc.

            regards, tom lane

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Hash or merge join instead of inner loop
Следующее
От: Joe Conway
Дата:
Сообщение: Re: Re-ordering .CONF params ... questions for this list