Re: Bitmap Heap scan 8.1/8.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bitmap Heap scan 8.1/8.2
Дата
Msg-id 10734.1193149332@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bitmap Heap scan 8.1/8.2  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Martin Marques escribi�:
>>> seq_page_cost = 5.0                     # measured on an arbitrary scale

> What people generally do around here is mess with random_page_cost, and
> leave seq_page_cost alone.

It's also worth pointing out that having seq_page_cost >
random_page_cost is simply not sane, and is very likely to result in
performance problems in other queries.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: How to speedup intarray aggregate function?
Следующее
От: Erik Jones
Дата:
Сообщение: Re: Determine query run-time from pg_* tables