Re: problems with set_config, work_mem, maintenance_work_mem, and sorting
Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> writes:
> On Tue, Feb 28, 2012 at 1:28 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
>> Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> writes:
>>> 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?
> If I am understanding this correctly, yes. They all share the same pid.
Hmph ... does seem a bit weird. Can you turn on log_statements and
identify which operations aren't using the session values?
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Home]
[Yosemite]