| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | "S Grannis" <sjg(at)email(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance Issues with count() |
| Date: | 2002-04-25 19:03:53 |
| Message-ID: | 20020425150353.2373c2d7.nconway@klamath.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Thu, 25 Apr 2002 13:54:40 -0500
"S Grannis" <sjg(at)email(dot)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(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grant Johnson | 2002-04-25 19:19:12 | Re: Performance Issues with count() |
| Previous Message | Tom Lane | 2002-04-25 18:58:06 | Re: pg_restore and permissions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grant Johnson | 2002-04-25 19:19:12 | Re: Performance Issues with count() |
| Previous Message | Tom Lane | 2002-04-25 19:03:51 | Re: explicitly casting return value of avg() to float4 |