Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group