Re: Column correlation drifts, index ignored again - Mailing list pgsql-performance

From Tom Lane
Subject Re: Column correlation drifts, index ignored again
Date
Msg-id 20484.1077507520@sss.pgh.pa.us
Whole thread Raw
In response to Re: Column correlation drifts, index ignored again  (John Siracusa <siracusa@mindspring.com>)
List pgsql-performance
John Siracusa <siracusa@mindspring.com> writes:
> Does the planner get estimates from both plans before deciding whether or
> not to use the one that references the date index?

The rowcount estimate is made prior to the plan cost estimate, much less
the plan selection.  So you'd see the same number either way.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: General performance questions about postgres on Apple
Next
From: "Eric Jain"
Date:
Subject: Slow join using network address function