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 > test? > > 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. Cheers, Jeff -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers