| 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
| 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 |