Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Tomi N/A" <hefest@xxxxxxxxx>
Subject: Re: Speed of postgres compared to ms sql, is this
From: Markus Schiltknecht <markus@xxxxxxxxxx>
Date: Wed, 06 Dec 2006 07:44:24 +0100
Cc: Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx>, pgsql general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <d487eb8e0612051813u2fbd8cbdq4f7d1b81b9acd62b@xxxxxxxxxxxxxx>
References: <7297298.post@xxxxxxxxxxxxxxx> <7298762.post@xxxxxxxxxxxxxxx> <b42b73150611131256k2055efe4va65f4a591413d7fb@xxxxxxxxxxxxxx> <7326226.post@xxxxxxxxxxxxxxx> <1163456616.6040.33.camel@xxxxxxxxxxxxxxxxxxxxxxx> <725602300612041018y5269031cp3f488042710ba865@xxxxxxxxxxxxxx> <d487eb8e0612051038n7f48890cl478aa5172f5ff5e5@xxxxxxxxxxxxxx> <10145.1165347271@xxxxxxxxxxxxx> <d487eb8e0612051432k56c9d73s53e17d7e3370af4e@xxxxxxxxxxxxxx> <1165358307.14565.464.camel@xxxxxxxxxxxxxxxxxxxxxxx> <d487eb8e0612051813u2fbd8cbdq4f7d1b81b9acd62b@xxxxxxxxxxxxxx>
User-agent: Icedove 1.5.0.8 (X11/20061128)

Hi,

Tomi N/A wrote:

> When the subselect returns a lot of results, pgsql really takes it'stime.
8.1.something

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


Regards

Markus

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Speed of postgres compared to ms sql, is this
  - From: Tomi N/A

References:
- Speed of postgres compared to ms sql, is this article/comment off?
  - From: novnov
- Re: Speed of postgres compared to ms sql, is this
  - From: novnov
- Re: Speed of postgres compared to ms sql, is this
  - From: Merlin Moncure
- Re: Speed of postgres compared to ms sql, is this
  - From: novnov
- Re: Speed of postgres compared to ms sql, is this
  - From: Scott Marlowe
- Re: Speed of postgres compared to ms sql, is this
  - From: Ian Harding
- Re: Speed of postgres compared to ms sql, is this
  - From: Tomi N/A
- Re: Speed of postgres compared to ms sql, is this
  - From: Tom Lane
- Re: Speed of postgres compared to ms sql, is this
  - From: Tomi N/A
- Re: Speed of postgres compared to ms sql, is this
  - From: Scott Marlowe
- Re: Speed of postgres compared to ms sql, is this
  - From: Tomi N/A

Prev by Date: Re: 8.2 contrib. "Full Disjunction"
Next by Date: Locking in PostgreSQL?
Previous by thread: Re: Speed of postgres compared to ms sql, is this
Next by thread: Re: Speed of postgres compared to ms sql, is this
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux