[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 Tue, Feb 28, 2012 at 4:46 PM, Claudio Freire <klaussfreire@xxxxxxxxx> wrote:
> On Tue, Feb 28, 2012 at 6:54 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
>>
>>> ... which is the ORM library (SQLAlchemy) doing a reflection of the
>>> table(s) involved.
>>
>> Oh, there's an ORM involved?  I'll bet a nickel it's doing something
>> surprising, like not issuing your SET until much later than you thought.
>
> I'd rather go for an auto-rollback at some point within the
> transaction that issued the set work_mem. SQLA tends to do that if,
> for instance, an exception is risen within a transaction block (ie,
> flushing).
>
> You can issue the set work_mem in its own transaction, and commit it,
> and in that way avoid that rollback.

I cranked the logging /all/ the way up and isolated the server.
I suspect that your theory is correct.
I'll spend a bit more time investigating.


-- 
Jon

-- 
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]

Powered by Linux