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

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

To: Pailloncy Jean-Gerard <jg@xxxxxxxx>
Subject: Re: 8.1 count(*) distinct: IndexScan/SeqScan
From: andrew@xxxxxxxxxxxx
Date: Wed, 23 Nov 2005 21:20:19 -0800
Cc: pgsql-performance@xxxxxxxxxxxxxx

Pailloncy Jean-Gerard <jg@xxxxxxxx> wrote ..
[snip]

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

> 
> postgres=# vaccum full verbose analyze;

Follow-Ups:
- Re: 8.1 count(*) distinct: IndexScan/SeqScan
  - From: Pailloncy Jean-Gerard

Prev by Date: Re: Hardware/OS recommendations for large databases (
Next by Date: Re: Hardware/OS recommendations for large databases (
Previous by thread: Re: 8.1 count(*) distinct: IndexScan/SeqScan
Next by thread: Re: 8.1 count(*) distinct: IndexScan/SeqScan
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