Re: Speedier count(*) - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Speedier count(*)
Date
Msg-id 42FA9A8B.1040400@commandprompt.com
Whole thread Raw
In response to Speedier count(*)  (Dan Harris <fbsd@drivefaster.net>)
List pgsql-performance
> 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.

This specific instance is fixed in 8.1

Sincerely,

Joshua D. Drake


>
>
> -Dan
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match


pgsql-performance by date:

Previous
From: Dan Harris
Date:
Subject: Speedier count(*)
Next
From: Michael Fuhr
Date:
Subject: Re: Speedier count(*)