Pailloncy Jean-Gerard <jg(at)rilk(dot)com> writes:
> Why the stupid indexscan plan on the whole table ?
Pray tell, what are you using for the planner cost parameters?
The only way I can come close to duplicating your numbers is
by setting random_page_cost to somewhere around 0.01 ...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: andrew||Date: 2005-11-24 05:20:19|
|Subject: Re: 8.1 count(*) distinct: IndexScan/SeqScan|
|Previous:||From: Luke Lonergan||Date: 2005-11-24 02:29:49|
|Subject: Re: Hardware/OS recommendations for large databases (|