Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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/

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2003-06-11 20:17:53
Subject: Re: tweaking costs to favor nestloop
Previous:From: pginfoDate: 2003-06-11 15:35:10
Subject: left join performance problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group