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: "Markus Schiltknecht" <markus@xxxxxxxxxx>
Subject: Re: Speed of postgres compared to ms sql, is this
From: "Tomi N/A" <hefest@xxxxxxxxx>
Date: Wed, 6 Dec 2006 20:59:53 +0000
Cc: "pgsql general" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <457666C8.8000808@xxxxxxxxxx>
References: <7297298.post@xxxxxxxxxxxxxxx> <7326226.post@xxxxxxxxxxxxxxx> <1163456616.6040.33.camel@xxxxxxxxxxxxxxxxxxxxxxx> <725602300612041018y5269031cp3f488042710ba865@xxxxxxxxxxxxxx> <d487eb8e0612051038n7f48890cl478aa5172f5ff5e5@xxxxxxxxxxxxxx> <10145.1165347271@xxxxxxxxxxxxx> <d487eb8e0612051432k56c9d73s53e17d7e3370af4e@xxxxxxxxxxxxxx> <1165358307.14565.464.camel@xxxxxxxxxxxxxxxxxxxxxxx> <d487eb8e0612051813u2fbd8cbdq4f7d1b81b9acd62b@xxxxxxxxxxxxxx> <457666C8.8000808@xxxxxxxxxx>

2006/12/6, Markus Schiltknecht <markus@xxxxxxxxxx>:

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.

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

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: 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
- Re: Speed of postgres compared to ms sql, is this
  - From: Markus Schiltknecht

Prev by Date: Trying to Understand Table Inheritance
Next by Date: Re: Restore database from files (not dump files)?
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]