Re: Spped of max - Mailing list pgsql-general

From Doug Fields
Subject Re: Spped of max
Date
Msg-id 5.1.0.14.2.20020514211711.01ee4248@mail.pexicom.com
Whole thread Raw
In response to Re: Spped of max  (nconway@klamath.dyndns.org (Neil Conway))
Responses Re: Spped of max
List pgsql-general
>Since PostgreSQL allows user-defined aggregates, this is somewhat
>difficult to optimize. No one has yet bothered to create special
>cases for max(), min() and perhaps count(), although it could
>probably be done.

Perhaps you can suggest the fastest way of getting a table count, if it is not

SELECT COUNT(*) FROM x WHERE ...;

Thanks,

Doug



pgsql-general by date:

Previous
From: nconway@klamath.dyndns.org (Neil Conway)
Date:
Subject: Re: Spped of max
Next
From: nconway@klamath.dyndns.org (Neil Conway)
Date:
Subject: Re: Spped of max