Search Postgresql Archives

Re: SQL WHERE: many sql or large IN()

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

To: tom <tom@xxxxxxxxxxx>
Subject: Re: SQL WHERE: many sql or large IN()
From: Markus Schiltknecht <markus@xxxxxxxxxx>
Date: Fri, 06 Apr 2007 18:45:15 +0200
Cc: Postgresql <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <5251CBA4-FDF4-450F-8011-6071806E24D0@xxxxxxxxxxx>
References: <5251CBA4-FDF4-450F-8011-6071806E24D0@xxxxxxxxxxx>
User-agent: Icedove 1.5.0.10 (X11/20070307)

Hi,

tom wrote:

Initially it seems that the WHERE IN (...) approach takes a turn for theworse when the list gets very large.

What version do you use? PostgreSQL 8.2 had great improvements for thatspecific issue. Did you try EXPLAIN?


Regards

Markus

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

Follow-Ups:
- Re: SQL WHERE: many sql or large IN()
  - From: Listmail

References:
- SQL WHERE: many sql or large IN()
  - From: tom

Prev by Date: Re: Anyone know where I can get an 8.2.3 binary for ubuntu?
Next by Date: No of triggers of one single table
Previous by thread: Re: SQL WHERE: many sql or large IN()
Next by thread: Re: SQL WHERE: many sql or large IN()
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