Re: Choice of bitmap scan over index scan

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Choice of bitmap scan over index scan
Дата
Msg-id 4B49A586020000250002E142@gw.wicourts.gov
обсуждение исходный текст
Ответ на Choice of bitmap scan over index scan  (Mathieu De Zutter <mathieu@dezutter.org>)
Список pgsql-performance
I wrote:

> work_mem = 32MB

Hmmm...  With 100 connections and 2 GB RAM, that is probably on the
high side, at least if you sometimes use a lot of those connections
at the same time to run queries which might use sorts or hashes. It's
probably safer to go down to 16MB or even back to where you had it.

Sorry I missed that before.

-Kevin



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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Choice of bitmap scan over index scan
Следующее
От: Robert Haas
Дата:
Сообщение: Re: PG optimization question