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

From Tom Lane
Subject Re: Yet another abort-early plan disaster on 9.3
Date
Msg-id 10321.1412094757@sss.pgh.pa.us
Whole thread Raw
In response to Re: Yet another abort-early plan disaster on 9.3  ("Graeme B. Bell" <grb@skogoglandskap.no>)
Responses Re: Yet another abort-early plan disaster on 9.3  ("Graeme B. Bell" <grb@skogoglandskap.no>)
List pgsql-performance
"Graeme B. Bell" <grb@skogoglandskap.no> writes:
> Every year or two the core count goes up. Can/should/does postgres ever attempt two strategies in parallel, in cases
wherestrategy A is generally good but strategy B prevents bad worst case behaviour? Kind of like a Schr�dinger's Cat
approachto scheduling. What problems would it raise? 

You can't run two plans and have them both returning rows to the client,
or performing inserts/updates/deletes as the case may be.

            regards, tom lane


pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Yet another abort-early plan disaster on 9.3
Next
From: Jeff Janes
Date:
Subject: Re: Yet another abort-early plan disaster on 9.3