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: | Raw Message | Whole Thread | 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 |