Re: Yet another abort-early plan disaster on 9.3 - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Yet another abort-early plan disaster on 9.3
Date
Msg-id CA+U5nMJqbcveiVL=cMCkzvOzSqPHytPROTbUnw8W6YRC=8T3Vw@mail.gmail.com
Whole thread Raw
In response to Re: Yet another abort-early plan disaster on 9.3  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Yet another abort-early plan disaster on 9.3
List pgsql-performance
On 12 December 2014 at 03:22, Simon Riggs <simon@2ndquadrant.com> wrote:

> It's a simple patch, but it solves the test cases I know about and
> does almost nothing to planning time.

Test cases attached. The files marked "pettus_*" are written up from
Christophe Pettus' blog.
The other test case is one of my own devising, based upon recent
customer problems.

The "10 most recent calls" is a restatement of actual problems seen in the past.


Also attached is a new parameter called enable_sortedpath which can be
used to turn on/off the sorted path generated by the planner.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Attachment

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Yet another abort-early plan disaster on 9.3
Next
From: Merlin Moncure
Date:
Subject: Re: 8xIntel S3500 SSD in RAID10 on Dell H710p