| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Tarcizio Bini <tarcizioab(at)c3sl(dot)ufpr(dot)br> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: GEQO Benchmark |
| Date: | 2008-05-28 16:52:40 |
| Message-ID: | 1211993560.4489.583.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, 2008-05-28 at 13:13 -0300, Tarcizio Bini wrote:
> Of course, the geqo_threshold can be changed so that the geqo be
> performed in queries that have less than 12 tables. However, we aim to
> test the GEQO algorithm in conditions where the standard algorithm
> (dynamic programming) has a high cost to calculate the query plan.
My understanding is the GEQO cannot arrive at a better plan than the
standard optimizer, so unless you wish to measure planning time there
isn't much to test. What is the quality of the plans it generates? Well
that varies according to the input; sometimes it gets the right plan,
other times it doesn't get close.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tarcizio Bini | 2008-05-28 17:54:56 | Re: GEQO Benchmark |
| Previous Message | Tarcizio Bini | 2008-05-28 16:13:38 | Re: GEQO Benchmark |