How can I show more potential query plans, other than the default one?

From: Yangyang <yangyangbm(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How can I show more potential query plans, other than the default one?
Date: 2011-11-17 02:21:48
Message-ID: CAN3Hncy1X9Zm4gJjGPc4ApYQe0Qs_pjZe=vw0V_J=rMa-cLF1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kai Otto 2011-11-17 12:05:39 UTF8 problem
Previous Message Jean-Yves F. Barbier 2011-11-16 21:35:52 Re: How to truncate? integers