Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL WHERE: many sql or large IN() - Mailing list pgsql-general

From Markus Schiltknecht
Subject Re: SQL WHERE: many sql or large IN()
Date
Msg-id 4616791B.5000704@bluegap.ch
Whole thread Raw
In response to SQL WHERE: many sql or large IN()  (tom <tom@tacocat.net>)
Responses Re: SQL WHERE: many sql or large IN()  (Listmail <lists@peufeu.com>)
List pgsql-general
Tree view 
Hi,

tom wrote:
> Initially it seems that the WHERE IN (...) approach takes a turn for the
> worse when the list gets very large.

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

Regards

Markus

pgsql-general by date:

Previous
From: Leonel
Date:
Subject: Re: Anyone know where I can get an 8.2.3 binary for ubuntu?
Next
From: "Harpreet Dhaliwal"
Date:
Subject: No of triggers of one single table