> What "same result"? You only ran it up to 2K rows, not 2M. In any
Sorry, I do this over and over until xxx.000 rows but I do not write
in the mail.
I do it again. initdb, create table, insert, vacuum full analyze,
explain analyze at each stage.
And there was no problem.
So I make a copy of the offending data directory, and try again. And
I got IndexScan only.
I will get an headheak ;-)
Too big to be send by mail: http://rilk.com/pg81.html
In response to
pgsql-performance by date
|Next:||From: Rodrigo Madera||Date: 2005-11-25 19:36:35|
|Subject: Newbie question: ultra fast count(*)|
|Previous:||From: Alvaro Herrera||Date: 2005-11-25 12:32:00|
|Subject: Re: 8.1 count(*) distinct: IndexScan/SeqScan|