Postgres Pro
Downloads
Home   >   mailing lists

Re: Speed of postgres compared to ms sql, is this - Mailing list pgsql-general

From Markus Schiltknecht
Subject Re: Speed of postgres compared to ms sql, is this
Date
Msg-id 457666C8.8000808@bluegap.ch
Whole thread Raw
In response to Re: Speed of postgres compared to ms sql, is this  ("Tomi N/A" <hefest@gmail.com>)
Responses Re: Speed of postgres compared to ms sql, is this  ("Tomi N/A" <hefest@gmail.com>)
List pgsql-general
Tree view 
Hi,

Tomi N/A wrote:
>> > When the subselect returns a lot of results, pgsql really takes it's
>> time.
>
> 8.1.something

PostgreSQL 8.2 improved a lot for IN clauses with lots of values. I
think it now performs as good as an equal join query.

Regards

Markus

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: 8.2 contrib. "Full Disjunction"
Next
From: Joost Kraaijeveld
Date:
Subject: Locking in PostgreSQL?