Skip site navigation (1) Skip section navigation (2)

Re: Slow count(*)

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Slow count(*)
Date: 2008-01-02 15:47:15
Message-ID: 162867790801020747r23f6fa09ke11609fc090ca33c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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

Responses

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group