Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Querying with multicolumn index - Mailing list pgsql-performance

From Tom Lane
Subject Re: [PERFORM] Querying with multicolumn index
Date
Msg-id 14684.1481417363@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] Querying with multicolumn index  (Eric Jiang <eric@doublemap.com>)
Responses Re: [PERFORM] Querying with multicolumn index
List pgsql-performance
Tree view 
Eric Jiang <eric@doublemap.com> writes:
> We aren't using any special planner settings - all enable_* options are "on".

No, I'm asking about the cost settings (random_page_cost etc).  The cost
estimates you're showing seem impossible with the default settings.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [PERFORM] Querying with multicolumn index
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] Querying with multicolumn index