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 would probably show a significant improvement.

Alban Hertroys

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


!DSPAM:737,4db98c8412122209668288!

In response to

• Re: GIN index not used at 2011-04-28 15:29:33 from Alban Hertroys

Responses

• Re: GIN index not used at 2011-04-29 17:04:38 from Mark
• Re: GIN index not used at 2011-04-30 18:37:18 from Mark

pgsql-general by date

Next:	From: Thomas Larsen Wessel	Date: 2011-04-28 15:55:55
	Subject: Re: Converting between varchar and float when updating
Previous:	From: Alban Hertroys	Date: 2011-04-28 15:40:41
	Subject: Re: Converting between varchar and float when updating