Re: [GENERAL] Performance of full outer join in 8.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] Performance of full outer join in 8.3
Date
Msg-id 1344.1239833053@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Performance of full outer join in 8.3  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: [GENERAL] Performance of full outer join in 8.3  (Robert Haas <robertmhaas@gmail.com>)
Re: [GENERAL] Performance of full outer join in 8.3  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> I've always been scared to ask this question, in case the answer is No,
> but: Do we have a set of regression tests for the optimizer anywhere?

Nothing beyond what is in the standard tests.  While that's okay at
catching wrong answers --- and we have memorialized a number of such
issues in the tests --- the framework is not good for catching things
that run slower than they ought.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [GENERAL] Performance of full outer join in 8.3
Next
From: Robert Haas
Date:
Subject: Re: [GENERAL] Performance of full outer join in 8.3