On Feb 29, 2012 1:44 AM, "Claudio Freire" <klaussfreire(at)gmail(dot)com> 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.
In response to
pgsql-performance by date
|Next:||From: Anssi Kääriäinen||Date: 2012-02-29 10:20:15|
|Subject: Large insert and delete batches|
|Previous:||From: Gavin Flower||Date: 2012-02-29 05:31:29|
|Subject: Re: Very long deletion time on a 200 GB database|