On Thu, Sep 17, 2009 at 1:19 PM, Alan McKay <alan.mckay@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
