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

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

2006/12/6, Markus Schiltknecht <markus(at)bluegap(dot)ch>:
> 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.

Thats good to know. I'm looking forward to taking it for a spin...as
soon as I make sure my data is safe.

t.n.a.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2006-12-06 21:26:08 Re: Restore database from files (not dump files)?
Previous Message Keary Suska 2006-12-06 20:58:10 Trying to Understand Table Inheritance