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

From Josh Berkus
Subject Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
Date
Msg-id 5245F11E.20804@agliodbs.com
Whole thread Raw
In response to Planner performance extremely affected by an hanging transaction (20-30 times)?  (Bartłomiej Romański <br@sentia.pl>)
Responses Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
List pgsql-performance
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


pgsql-performance by date:

Previous
From: Jim Garrison
Date:
Subject: Re: Troubleshooting query performance issues - resolved (sort of)
Next
From: Andres Freund
Date:
Subject: Re: Planner performance extremely affected by an hanging transaction (20-30 times)?