Postgres Pro
Downloads
Home   >   mailing lists

Re: 200 times slower then MSSQL?? - Mailing list pgsql-performance

From Tom Lane
Subject Re: 200 times slower then MSSQL??
Date
Msg-id 5223.1106676143@sss.pgh.pa.us
Whole thread Raw
In response to 200 times slower then MSSQL??  ("Alexander Dolgin" <alex@dolgin.dp.ua>)
List pgsql-performance
Tree view 
"Alexander Dolgin" <alex@dolgin.dp.ua> writes:
> Does anybody have idea about reasons of such results?

Try converting the MAX() functions to queries that will use indexes.
See FAQ entry 4.7 "My queries are slow or don't make use of the
indexes. Why?"

            regards, tom lane

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: 200 times slower then MSSQL??
Next
From: Kaloyan Iliev Iliev
Date:
Subject: Re: 200 times slower then MSSQL??