Re: 8.1 count(*) distinct: IndexScan/SeqScan - Mailing list pgsql-performance

From Pailloncy Jean-Gerard
Subject Re: 8.1 count(*) distinct: IndexScan/SeqScan
Date
Msg-id D629E6A4-81A4-42F0-9702-68883971F05E@rilk.com
Whole thread Raw
In response to Re: 8.1 count(*) distinct: IndexScan/SeqScan  (andrew@pillette.com)
List pgsql-performance
> THIS MAY SEEM SILLY but vacuum is mispelled below and presumably
> there was never any ANALYZE done.
>
>>
>> postgres=# vaccum full verbose analyze;
I do have done the "vacUUm full verbose analyze;".
But I copy/paste the wrong line.

Cordialement,
Jean-Gérard Pailloncy


pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: Pailloncy Jean-Gerard
Date:
Subject: Re: 8.1 count(*) distinct: IndexScan/SeqScan