Skip site navigation (1) Skip section navigation (2)

Re: GIN index not used

From: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
To: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
Cc: Mark <Marek(dot)Balgar(at)seznam(dot)cz>, pgsql-general(at)postgresql(dot)org
Subject: Re: GIN index not used
Date: 2011-04-28 15:49:20
Message-ID: 40DF62D9-B3F8-4564-941D-D59FA584A522@solfertje.student.utwente.nl (view raw or flat)
Thread:
Lists: 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 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

Responses

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group