Re: Planner performance extremely affected by an hanging transaction (20-30 times)?

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

 



Andres, Jeff,


>> As far as I can tell, the only downside of doing that is that, since hint
>> bits might be set later, it is possible some dirty pages will get written
>> unhinted and then re-dirtied by the hint bit setting, when more aggressive
>> setting would have only one combined dirty write instead.  But that seems
>> rather hypothetical, and if it really is a problem we should probably
>> tackle it directly rather than by barring other optimizations.
> 
> I am - as evidenced - too tired to think about this properly, but I
> think you might be right here.

Any thoughts on a fix for this we could get into 9.2.5?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


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

  Powered by Linux