How can I show more potential query plans, other than the default one? - Mailing list pgsql-novice

From Yangyang
Subject How can I show more potential query plans, other than the default one?
Date
Msg-id CAN3Hncy1X9Zm4gJjGPc4ApYQe0Qs_pjZe=vw0V_J=rMa-cLF1g@mail.gmail.com
Whole thread Raw
Responses Re: How can I show more potential query plans, other than the default one?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hi,
I want to see more query plans, other than the default one for a query
and compare their cost. Based on this, I can change the cost model and
see how that can affect the cost model?
I enabled the debug information in postgresql.conf. But it looks like
the output is still for the best plan only. Is there any way to see
them, before I go to the code and implement sth myself?
Thanks very much.
-Yangyang

pgsql-novice by date:

Previous
From: Steve Crawford
Date:
Subject: Re: How to truncate? integers
Next
From: "Kai Otto"
Date:
Subject: UTF8 problem