Postgres Pro
Downloads
Home   >   mailing lists

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

From Jesper Krogh
Subject Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
Date
Msg-id 51CA92A1-7109-4539-8990-0A111E48E943@krogh.cc
Whole thread Raw
In response to Re: Planner performance extremely affected by an hanging transaction (20-30 times)?  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
Tree view

On 21/09/2013, at 00.01, Jeff Janes <jeff.janes@gmail.com> wrote:
See "In progress INSERT wrecks plans on table" and "Performance bug in prepared statement binding in 9.2" also on this list

This feels like the same




The issues are:

1) The planner actually queries the relation to find the end points of the variable ranges, rather than using potentially out-of-date statistics.


In my app i would prefer potentially out-of-date statistics instead.

Jesper

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Planner performance extremely affected by an hanging transaction (20-30 times)?
Next
From: Kevin Grittner
Date:
Subject: Re: Planner performance extremely affected by an hanging transaction (20-30 times)?