Re: GIN index not used - Mailing list pgsql-general

From Alban Hertroys
Subject Re: GIN index not used
Date
Msg-id 40DF62D9-B3F8-4564-941D-D59FA584A522@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: GIN index not used  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Responses Re: GIN index not used
Re: GIN index not used
List 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 by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Converting between varchar and float when updating
Next
From: Thomas Larsen Wessel
Date:
Subject: Re: Converting between varchar and float when updating