Re: Speed of postgres compared to ms sql, is this

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: "Tomi N/A" <hefest(at)gmail(dot)com>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Speed of postgres compared to ms sql, is this
Date: 2006-12-06 06:44:24
Message-ID: 457666C8.8000808@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joost Kraaijeveld 2006-12-06 07:04:12 Locking in PostgreSQL?
Previous Message Richard Broersma Jr 2006-12-06 06:29:35 Re: 8.2 contrib. "Full Disjunction"