Re: annoying query/planner choice

Поиск
Список
Период
Сортировка
От Dennis Bjorklund
Тема Re: annoying query/planner choice
Дата
Msg-id Pine.LNX.4.44.0401120449300.13405-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на annoying query/planner choice  (Andrew Rawnsley <ronz@ravensfield.com>)
Ответы Re: annoying query/planner choice  (Andrew Rawnsley <ronz@ravensfield.com>)
Список pgsql-performance
On Sun, 11 Jan 2004, Andrew Rawnsley wrote:

> 20-25% of the time. Fiddling with CPU_TUPLE_COST doesn't do anything
> until I exceed 0.5, which strikes me as a bit high (though please
> correct me if I am assuming too much...). RANDOM_PAGE_COST seems to have
> no effect.

What about the effective cache size, is that set properly?

--
/Dennis Björklund


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

Предыдущее
От: Andrew Rawnsley
Дата:
Сообщение: annoying query/planner choice
Следующее
От: Andrew Rawnsley
Дата:
Сообщение: Re: annoying query/planner choice