| From: | Vincent van Leeuwen <pgsql(dot)spam(at)vinz(dot)nl> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | tweaking costs to favor nestloop |
| Date: | 2003-06-11 19:33:14 |
| Message-ID: | 20030611193313.GE1535@md2.mediadesign.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi,
I'm running PG 7.3.2 on a dual P3 1 GHz, 4GB RAM, 5-disk RAID 5 (hardware) on
Debian Linux, kernel 2.4.21-rc3.
I'm unable to tweak the various _cost settings in such a way that attached
query will use the right plan. Attachment contains relevant config file
settings, table defenitions and explain analyze output with some enable_*
settings turned off.
Could anyone tell me what I'm doing wrong in the query itself or tell me what
I should do with which config file setting to let the planner choose the
fastest plan by itself?
Regards,
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
| Attachment | Content-Type | Size |
|---|---|---|
| nestloop | text/plain | 8.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-06-11 20:17:53 | Re: tweaking costs to favor nestloop |
| Previous Message | pginfo | 2003-06-11 15:35:10 | left join performance problem |