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?
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2003-06-11 20:17:53|
|Subject: Re: tweaking costs to favor nestloop |
|Previous:||From: pginfo||Date: 2003-06-11 15:35:10|
|Subject: left join performance problem|