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: (view raw or whole thread)
Lists: pgsql-performance

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 -


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-2015 The PostgreSQL Global Development Group