Re: 8.1 count(*) distinct: IndexScan/SeqScan

From: Pailloncy Jean-Gerard <jg(at)rilk(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: 8.1 count(*) distinct: IndexScan/SeqScan
Date: 2005-11-25 14:47:16
Message-ID: 78D03263-E40B-4E49-964C-D8013225247F@rilk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

Cordialement,
Jean-Gérard Pailloncy

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rodrigo Madera 2005-11-25 19:36:35 Newbie question: ultra fast count(*)
Previous Message Alvaro Herrera 2005-11-25 12:32:00 Re: 8.1 count(*) distinct: IndexScan/SeqScan