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

• Re: Slow count(*) at 2008-01-02 15:47:15 from Pavel Stehule
• Re: Slow count(*) at 2008-01-02 15:50:52 from A. Kretschmer
• Re: Slow count(*) at 2008-01-02 16:25:39 from Andrew Sullivan
• Re: Slow count(*) at 2008-01-02 18:12:47 from Simon Riggs
• Re: Slow count(*) at 2008-01-03 15:15:59 from Kevin Grittner

pgsql-hackers by date

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

pgsql-general by date

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