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

Re: generalizing the planner knobs

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: generalizing the planner knobs
Date: 2005-12-01 17:32:12
Message-ID: dmnc17$30b9$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
"Neil Conway" <neilc(at)samurai(dot)com> wrote
>
> This would also be useful when diagnosing bad query plans: for example,
> setting enable_seqscan=false often causes the planner to disregard the
> use of *any* sequential scan, anywhere in the plan. The ability to
> slightly bump up the cost of particular operations would allow more
> alternative plans to be examined.
>

This method also has the problem of "enable_seqscan=false" in some 
situations. I would vote we implement the final general solution like query 
plan hints directly.

Regards,
Qingqing 



In response to

Responses

pgsql-hackers by date

Next:From: Qingqing ZhouDate: 2005-12-01 17:52:48
Subject: Re: [PATCHES] A couple of proposed pgbench changes
Previous:From: Richard HuxtonDate: 2005-12-01 17:25:22
Subject: Re: 8.1, OID's and plpgsql

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