Re: Speedier count(*)

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Dan Harris <fbsd(at)drivefaster(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Speedier count(*)
Date: 2005-08-11 00:23:39
Message-ID: 42FA9A8B.1040400@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Fuhr 2005-08-11 00:36:35 Re: Speedier count(*)
Previous Message Dan Harris 2005-08-10 23:37:49 Speedier count(*)