Re: 200 times slower then MSSQL??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Alexander Dolgin" <alex(at)dolgin(dot)dp(dot)ua>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 200 times slower then MSSQL??
Date: 2005-01-25 18:02:23
Message-ID: 5223.1106676143@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Alexander Dolgin" <alex(at)dolgin(dot)dp(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Kaloyan Iliev Iliev 2005-01-25 18:09:24 Re: 200 times slower then MSSQL??
Previous Message Steve Atkins 2005-01-25 17:59:20 Re: PostgreSQL vs. Oracle vs. Microsoft