count(*) and bad design was: Experiences with extensibility - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject count(*) and bad design was: Experiences with extensibility
Date
Msg-id 20080109102935.6010ec20@webthatworks.it
Whole thread Raw
In response to Re: Experiences with extensibility  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: count(*) and bad design was: Experiences with extensibility
List pgsql-general
On Wed, 09 Jan 2008 00:06:45 -0800
"Joshua D. Drake" <jd@commandprompt.com> wrote:

> Granted there are scenarios where others are FASTER (SELECT
> COUNT(*)) but I find that if you are doing those items, you
> normally have a weird design anyway.

> Sincerely,

Sincerely, would you make an example of such a bad design?

Or did you just mean that count(*) is bad design in postgresql since
there are usually better alternatives in postgresql?

I'm not joking. I'd like to learn.

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Experiences with extensibility
Next
From: Rayudu Madhava
Date:
Subject: PgSql Mirroring/Fail Over Server