| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2008-01-02 15:50:52 | Re: Slow count(*) |
| Previous Message | Andrew Sullivan | 2008-01-02 15:32:08 | Re: basic questions: Postgres with yum on CentOS 5.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2008-01-02 15:50:52 | Re: Slow count(*) |
| Previous Message | Abraham, Danny | 2008-01-02 15:29:24 | Slow count(*) |