| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Larsen Wessel | 2011-04-28 15:55:55 | Re: Converting between varchar and float when updating |
| Previous Message | Alban Hertroys | 2011-04-28 15:40:41 | Re: Converting between varchar and float when updating |