[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: problems with set_config, work_mem, maintenance_work_mem, and sorting

On Feb 29, 2012 1:44 AM, "Claudio Freire" <klaussfreire@xxxxxxxxx> wrote:
> Another option, depending on your SQLA version, when connections are
> sent back to the pool, I seem to remember they were reset. That would
> also reset the work_mem, you'd still see the same pid on PG logs, but
> it's not the same session.

Except that any open transactions are rolled back no other reset is done. The correct way to handle this would be to set the options and commit the transaction in Pool connect or checkout events. The event choice depends on whether application scope or request scope parameters are wanted.

Ants Aasma

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Home]     [Yosemite]

Powered by Linux