Re: limiting query time and/or RAM

On Thu, Sep 17, 2009 at 1:19 PM, Alan McKay <alan(dot)mckay(at)gmail(dot)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.