| From: | "Justin Graf" <justin(at)emproshunts(dot)com> |
|---|---|
| To: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: same query in high number of times |
| Date: | 2009-06-21 20:51:24 |
| Message-ID: | 20512486315429@mail.emproshunts.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
---- Message from mailto:gryzman(at)gmail(dot)com Grzegorz Jaśkiewicz gryzman(at)gmail(dot)com at 06-21-2009 09:36:01 PM ------
On Sun, Jun 21, 2009 at 9:01 PM, Justin Grafjustin(at)emproshunts(dot)com wrote:
work_mem = 51024 # min 64, size in KB
Thats allot memory dedicated to work mem if you have 30 connections open
this could eat up 1.5gigs pushing the data out of cache.
I thought work memory is max memory that can be allocated per
connection for sorting, etc. I think it is not allocated when
connection is opened, but only on 'if needed' basis.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Alban | 2009-06-21 20:59:49 | Re: same query in high number of times |
| Previous Message | Grzegorz Jaśkiewicz | 2009-06-21 20:36:01 | Re: same query in high number of times |