Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance Issues with count() - Mailing list pgsql-general

From Neil Conway
Subject Re: Performance Issues with count()
Date
Msg-id 20020425150353.2373c2d7.nconway@klamath.dyndns.org
Whole thread Raw
In response to Re: Performance Issues with count()  ("S Grannis" <sjg@email.com>)
List pgsql-general
Tree view 
On Thu, 25 Apr 2002 13:54:40 -0500
"S Grannis" <sjg@email.com> wrote:
> enable_seqscan = 0      # per a recommendation

This is a bad idea -- I'd recommend you leave this set to 'true',
particularly since it doesn't help your particular case.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: "S Grannis"
Date:
Subject: Re: Performance Issues with count()
Next
From: Tom Lane
Date:
Subject: Re: explicitly casting return value of avg() to float4