John Siracusa <siracusa(at)mindspring(dot)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
In response to
pgsql-performance by date
|Next:||From: Eric Jain||Date: 2004-02-23 11:48:02|
|Subject: Slow join using network address function|
|Previous:||From: Tom Lane||Date: 2004-02-23 03:24:29|
|Subject: Re: General performance questions about postgres on Apple |