On 02/01/2008, Abraham, Danny <[EMAIL PROTECTED]> wrote: > 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?
There isn't any similar patch and will not be. Use materialized views or similar techniques. Are you sure, so all your problems are only in SELECT COUNT(*)? Check, please, all slow queries. Regards Pavel Stehule > > Danny Abraham > BMC Software > CTM&D Business Unit > 972-52-4286-513 > [EMAIL PROTECTED] > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings