From: | Guillaume Smet <guillaume(dot)smet(at)openwide(dot)fr> |
---|---|
To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: weird performances problem |
Date: | 2005-11-22 09:49:22 |
Message-ID: | 4382E9A2.5080102@openwide.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Andrew,
> I would be very suspicious of that much memory for sort. Please see
> the docs for what that does. That is the amount that _each sort_ can
> allocate before spilling to disk.
> If some set of your users are
> causing complicated queries with, say, four sorts apiece, then each
> user is potentially allocating 4x that much memory. That's going to
> wreak havoc on your disk buffers (which are tricky to monitor on most
> systems, and impossible on some).
Yes, we have effectively complicated queries. That's why we put the
sort_mem so high. I'll see if we can put it lower for the next few days
to see if it improves our performances.
Thanks for your help.
--
Guillaume
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Smet | 2005-11-22 09:56:40 | Re: weird performances problem |
Previous Message | Qingqing Zhou | 2005-11-22 07:21:12 | Re: weird performances problem |