Re: GIN index not used

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: GIN index not used
Дата
Msg-id 40DF62D9-B3F8-4564-941D-D59FA584A522@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на Re: GIN index not used  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Ответы Re: GIN index not used  (Mark <Marek.Balgar@seznam.cz>)
Re: GIN index not used  (Mark <Marek.Balgar@seznam.cz>)
Список pgsql-general
Дерево обсуждения 
On 28 Apr 2011, at 17:29, Alban Hertroys wrote:
> With 2.5GB of memory (such a strange number) the docs suggest about 250MB.

Correction, 25% of 2.5GB isn't 250MB of course. It would be somewhat over 500MB, although it's really just a
rule-of-thumb(no point in calculating exact numbers). Anyway, much more than you've currently configured, so even 250MB
wouldprobably show a significant improvement. 

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4db98c8412122209668288!

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Converting between varchar and float when updating
Следующее
От: Thomas Larsen Wessel
Дата:
Сообщение: Re: Converting between varchar and float when updating