Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I make PostgreSQL to select another quey plan? - Mailing list pgsql-novice

From Sean Davis
Subject Re: How can I make PostgreSQL to select another quey plan?
Date
Msg-id CANeAVB=d_z6mTrsMkPu+NttccZS_MgH9+AFSuxy61ru7fZy=PA@mail.gmail.com
Whole thread Raw
In response to How can I make PostgreSQL to select another quey plan?  (Yangyang <yangyangbm@gmail.com>)
Responses Re: How can I make PostgreSQL to select another quey plan?  (Yangyang <yangyangbm@gmail.com>)
List pgsql-novice
Tree view


On Wed, Nov 30, 2011 at 10:51 AM, Yangyang <yangyangbm@gmail.com> wrote:
HI, dear all
I'm trying to force the database to select another query plan for a
query, rather than the optimal one.
I changed query tuning related parameters, but the query plan stays
the same. Although the costs for nodes changed correspondingly,
What parameters can I modify to force the DB to select another plan?
Any hints will be helpful.

What is the database structure, query, and plan?  What do you want to have changed?  

Sean 

pgsql-novice by date:

Previous
From: Yangyang
Date:
Subject: How can I make PostgreSQL to select another quey plan?
Next
From: Yangyang
Date:
Subject: Re: How can I make PostgreSQL to select another quey plan?