Skip site navigation (1) Skip section navigation (2)

Re: Column correlation drifts, index ignored again

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: siracusa(at)mindspring(dot)com
Cc: Postgres Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Column correlation drifts, index ignored again
Date: 2004-02-23 03:38:40
Message-ID: 20484.1077507520@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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 JainDate: 2004-02-23 11:48:02
Subject: Slow join using network address function
Previous:From: Tom LaneDate: 2004-02-23 03:24:29
Subject: Re: General performance questions about postgres on Apple

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group