| 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.
| 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 |