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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

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