| From: | Ms swati chande <swativc(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | GeQo Pool Size and plan worth |
| Date: | 2009-07-24 04:40:37 |
| Message-ID: | 251879.86137.qm@web112610.mail.gq1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
While trying out query executions using the geqo, I could not understand the following output.
The geqo paramaters are set to default values. (pool_size=0).
When the pool_size and the worth of the plans was displayed, the following values were obtained, irrespective of the number of relations in the query.
For a query with 50 relations:
GEQO selected 250 pool entries,
best 8385954963095356800000000000000000000000000000000.00,
midvl 8385954963095356800000000000000000000000000000000.00,
worst 8385954963095356800000000000000000000000000000000.00.
For a query with 20 relations:
GEQO selected 250 pool entries,
best 45771829382598713000.00,
midvl 45771829382598713000.00,
worst 45771829382598713000.00.
For a query with 15 relations:
GEQO selected 250 pool entries,
best 6801044405876.81,
midvl 6801044405876.81,
worst 6801044405876.81.
Please help me understand this.
Regards
Swati
| From | Date | Subject | |
|---|---|---|---|
| Next Message | daveg | 2009-07-24 05:28:10 | Re: display previous query string of idle-in-transaction |
| Previous Message | Brendan Jurd | 2009-07-24 04:34:10 | Re: When is a record NULL? |