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: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackers

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

Any ideas?

Danny Abraham
BMC Software
CTM&D Business Unit


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-2018 The PostgreSQL Global Development Group