tweaking costs to favor nestloop

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

Responses

Browse pgsql-performance by date

  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