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

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: tom <tom(at)tacocat(dot)net>
Cc: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: SQL WHERE: many sql or large IN()
Date: 2007-04-06 16:45:15
Message-ID: 4616791B.5000704@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harpreet Dhaliwal 2007-04-06 17:10:13 No of triggers of one single table
Previous Message Leonel 2007-04-06 16:37:08 Re: Anyone know where I can get an 8.2.3 binary for ubuntu?