Re: WHERE IN (subselect) versus WHERE IN (1,2,3,)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Goess <kgoess(at)bepress(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WHERE IN (subselect) versus WHERE IN (1,2,3,)
Date: 2012-03-20 13:58:38
Message-ID: 24314.1332251918@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin Goess <kgoess(at)bepress(dot)com> writes:
> Thanks for looking into it, Tom. We're using 9.0.4, so that might indeed
> be the problem. What additional data (if any) would you like to see?

Well, the first thing to do is update to 9.0.latest and see if the plan
changes. There are plenty of good reasons to do that besides this
issue; see the release notes.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sam Loy 2012-03-20 14:22:07 Is it even possible?
Previous Message Albe Laurenz 2012-03-20 12:10:53 Re: Conditionnal validation for transaction