Postgres Pro
Downloads
Home   >   mailing lists

Slow count(*) - Mailing list pgsql-hackers

From Abraham, Danny
Subject Slow count(*)
Date
Msg-id BE67D1149BBD5746984545ED91F702E04DCC7A@hou-ex-02.adprod.bmc.com
Whole thread Raw
Responses Re: Slow count(*)  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: Slow count(*)  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Slow count(*)  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Slow count(*)  (Simon Riggs <simon@2ndquadrant.com>)
Re: Slow count(*)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
Tree view 
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@bmc.com

pgsql-hackers by date:

Previous
From: "Usama Dar"
Date:
Subject: Autovacuum & Table List Ordering
Next
From: "Pavel Stehule"
Date:
Subject: Re: Slow count(*)