| From: | Hannu Krosing <hannu(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Simon Riggs <simon(at)2ndQuadrant(dot)com>, Christian Schröder <cs(at)deriva(dot)de>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Performance of full outer join in 8.3 |
| Date: | 2009-04-18 10:50:50 |
| Message-ID: | 1240051850.7401.7.camel@huvostro |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Wed, 2009-04-15 at 18:04 -0400, Tom Lane wrote:
> Simon Riggs <simon(at)2ndQuadrant(dot)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.
Can't we make first cut at it by just running with timings on and then
compare ratios of running times - maybe with 2-3X tolerance - to catch
most obvious regressions ?
> regards, tom lane
--
Hannu Krosing http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability
Services, Consulting and Training
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2009-04-18 12:07:23 | Re: [GENERAL] Performance of full outer join in 8.3 |
| Previous Message | Irene Barg | 2009-04-18 10:23:49 | Re: number of relations reported by vacuumdb -av |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2009-04-18 11:26:47 | Re: Patch for 8.5, transformationHook |
| Previous Message | Pavel Golub | 2009-04-18 09:31:54 | [PATCH] Borland C Compiler compatibility issues |