Postgres Pro
Downloads
Home   >   mailing lists

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

From Yangyang
Subject How can I make PostgreSQL to select another quey plan?
Date
Msg-id CAN3Hncwwub5dk5vtDM-EDyp79qgxm0DBaKCworZN+6E8d4xbAg@mail.gmail.com
Whole thread Raw
Responses Re: How can I make PostgreSQL to select another quey plan?  (Sean Davis <sdavis2@mail.nih.gov>)
Re: How can I make PostgreSQL to select another quey plan?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
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.
Thanks!
-Yangyang

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: Re: index type
Next
From: Sean Davis
Date:
Subject: Re: How can I make PostgreSQL to select another quey plan?