On Thu, Sep 17, 2009 at 1:19 PM, Alan McKay <alan.mckay@gmail.com> wrote:
>> Generally speaking work_mem limits ram used. What are your
>> non-default postgresql.conf settings?
>
> This cannot be right because we had queries taking 4G and see our
> setting is such :
Are you sure they were using that much memory? If you see this in TOP:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
8528 postgres 16 0 8458m 359m 349m R 38.7 1.1 0:04.46 postgres:
You do know that the query here is using 359-349 Megs, right, not 8G.
> work_mem = 2MB # min 64kB
>
> I'll have to find a copy of the default file to figure out what my
> non-defaults are
Just look for things that have no # in front of them.