On Sat, Dec 12, 2015 at 9:48 AM, Corey Huinker <corey.huin...@gmail.com> wrote:
> What, if any, other load should be placed on the underlying table during the
> I ask because CIC statements that run in seconds on our staging machine can
> take many hours on our production machine, when most of the access is just
> reads, though those reads may have been part of a larger transaction that
> did updates elsewhere.
That sounds like the CIC is just blocked waiting for long-lived
transactions to go away. There isn't much that changes to the sorting
algorithm can do about that.
Sent via pgsql-hackers mailing list (email@example.com)
To make changes to your subscription: