Postgres Pro
Downloads
Home   >   mailing lists

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

From andrew@pillette.com
Subject Re: 8.1 count(*) distinct: IndexScan/SeqScan
Date
Msg-id 200511240520.jAO5KJx03991@pillette.com
Whole thread Raw
In response to 8.1 count(*) distinct: IndexScan/SeqScan  (Pailloncy Jean-Gerard <jg@rilk.com>)
Responses Re: 8.1 count(*) distinct: IndexScan/SeqScan
List pgsql-performance
Tree view 
Pailloncy Jean-Gerard <jg@rilk.com> wrote ..
[snip]

THIS MAY SEEM SILLY but vacuum is mispelled below and presumably there was never any ANALYZE done.

>
> postgres=# vaccum full verbose analyze;

pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: "Luke Lonergan"
Date:
Subject: Re: Hardware/OS recommendations for large databases (