Slow count(*)

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Slow count(*)
Date: 2008-01-02 15:29:24
Message-ID: BE67D1149BBD5746984545ED91F702E04DCC7A@hou-ex-02.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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?

Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham(at)bmc(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-01-02 15:32:08 Re: basic questions: Postgres with yum on CentOS 5.1
Previous Message Pavel Stehule 2008-01-02 15:25:37 Re: Creating XML/KML documents from single tables

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2008-01-02 15:47:15 Re: Slow count(*)
Previous Message Usama Dar 2008-01-02 15:00:10 Autovacuum & Table List Ordering