On Thu, Aug 19, 2010 at 15:42, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Jeremy Palmer <JPalmer@xxxxxxxxxxxx> writes: >> Could it be that I have too much memory allocated for postgresql? My resource settings are: >> shared_buffers = 94952 >> temp_buffers = 1GB >> work_mem = 19339 >> maintenance_work_mem = 191845 >> max_stack_depth = 2MB > > 1GB for temp_buffers is a *LOT*. You do realize that's per backend? > Those other settings don't look too unreasonable. Definitely - particularly since this is a 32-bit version, that's getting very close to the address space limits... -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
