Postgres Pro
Downloads
Home   >   mailing lists

Re: problems with set_config, work_mem, maintenance_work_mem, and sorting - Mailing list pgsql-performance

From Tom Lane
Subject Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
Date
Msg-id 9466.1330457283@sss.pgh.pa.us
Whole thread Raw
In response to problems with set_config, work_mem, maintenance_work_mem, and sorting  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Responses Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
List pgsql-performance
Tree view 
Jon Nelson <jnelson+pgsql@jamponi.net> writes:
> The config shows 128MB for work_mem and 2GB for maintenance_work_mem.
> Why does PostgreSQL /sometimes/ use the globally-configured values and
> sometimes use the values that come from the connection?

You sure those log entries are all from the same process?

            regards, tom lane

pgsql-performance by date:

Previous
From: Jon Nelson
Date:
Subject: problems with set_config, work_mem, maintenance_work_mem, and sorting
Next
From: Jon Nelson
Date:
Subject: Re: problems with set_config, work_mem, maintenance_work_mem, and sorting