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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: 8.1 count(*) distinct: IndexScan/SeqScan
From: Pailloncy Jean-Gerard <jg@xxxxxxxx>
Date: Thu, 24 Nov 2005 12:54:25 +0100
Cc: andrew@xxxxxxxxxxxx
In-reply-to: <200511240520.jAO5KJx03991@xxxxxxxxxxxx>
References: <200511240520.jAO5KJx03991@xxxxxxxxxxxx>

THIS MAY SEEM SILLY but vacuum is mispelled below and presumablythere 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

References:
- Re: 8.1 count(*) distinct: IndexScan/SeqScan
  - From: andrew

Prev by Date: Re: Hardware/OS recommendations for large databases (
Next by Date: Re: 8.1 count(*) distinct: IndexScan/SeqScan
Previous by thread: Re: 8.1 count(*) distinct: IndexScan/SeqScan
Next by thread: xlog flush request error
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux