| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | Justin Graf <justin(at)emproshunts(dot)com> |
| Cc: | Peter Alban <peter(dot)alban2(at)gmail(dot)com>, Robert Haas <robertmhaas(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:36:01 |
| Message-ID: | 2f4958ff0906211336t4f732d0cycdc4c39f97a50472@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sun, Jun 21, 2009 at 9:01 PM, Justin Graf<justin(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.
--
GJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Graf | 2009-06-21 20:51:24 | Re: same query in high number of times |
| Previous Message | Justin Graf | 2009-06-21 20:01:33 | Re: same query in high number of times |