On 02/01/2008, Abraham, Danny <danny_abraham(at)bmc(dot)com> wrote:
> Hi,
>
> We are looking for a patch that will help us  count using the indexes.
>
> Our product is about 20 times slower on Postgres compared to MS SQL
> Server.
>
> Any ideas?

There isn't any similar patch and will not be.

Use materialized views or similar techniques.

Are you sure, so all your problems are only in SELECT COUNT(*)?

Check, please, all slow queries.

Regards
Pavel Stehule
>
> Danny Abraham
> BMC Software
> CTM&D Business Unit
> 972-52-4286-513
> danny_abraham(at)bmc(dot)com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

In response to

• Slow count(*) at 2008-01-02 15:29:24 from Abraham, Danny

Responses

• Re: [HACKERS] Slow count(*) at 2008-01-02 16:42:53 from Pavel Stehule

pgsql-hackers by date

Next:	From: A. Kretschmer	Date: 2008-01-02 15:50:52
	Subject: Re: Slow count(*)
Previous:	From: Abraham, Danny	Date: 2008-01-02 15:29:24
	Subject: Slow count(*)

pgsql-general by date

Next:	From: A. Kretschmer	Date: 2008-01-02 15:50:52
	Subject: Re: Slow count(*)
Previous:	From: Andrew Sullivan	Date: 2008-01-02 15:32:08
	Subject: Re: basic questions: Postgres with yum on CentOS 5.1