Jaime Casanova wrote:
> But, IMHO, if the table has 143902 and it thinks will retrieve 2610
> (almost 1.81% of the total). it won't be faster with an index?
Depends on how those 2610 rows are distributed amongst the 143902. The
worst case scenario is each one of them in its own page. In that case
you have to read 2610 *pages*, which is probably a significant
percentage of the table.
You can find out this information from the pg_stats view (particularly
the correlation column).
In response to
pgsql-performance by date
|Next:||From: Hasnul Fadhly bin Hasan||Date: 2005-02-14 08:01:20|
|Previous:||From: Tom Lane||Date: 2005-02-14 03:38:01|
|Subject: Re: estimated rows vs. actual rows |