Re: Speedier count(*)

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Dan Harris <fbsd(at)drivefaster(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Speedier count(*)
Date: 2005-08-11 00:36:35
Message-ID: 20050811003635.GA69508@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Aug 10, 2005 at 05:37:49PM -0600, Dan Harris wrote:
> Also, I am using "select ... group by ... order by .. limit 1" to get
> the min/max since I have already been bit by the issue of min() max()
> being slower.

PostgreSQL 8.1 will have optimizations for certain MIN and MAX
queries.

http://archives.postgresql.org/pgsql-committers/2005-04/msg00163.php
http://archives.postgresql.org/pgsql-committers/2005-04/msg00168.php

--
Michael Fuhr

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-08-11 01:07:50 Re: Speedier count(*)
Previous Message Joshua D. Drake 2005-08-11 00:23:39 Re: Speedier count(*)