Re: Spped of max

From: Doug Fields <dfields-pg-general(at)pexicom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Spped of max
Date: 2002-05-15 01:18:43
Message-ID: 5.1.0.14.2.20020514211711.01ee4248@mail.pexicom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2002-05-15 01:58:55 Re: Spped of max
Previous Message Neil Conway 2002-05-15 00:28:55 Re: Spped of max