| From: | Jim Nasby <jnasby(at)enova(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Problems with hash join over nested loop |
| Date: | 2013-10-28 23:53:03 |
| Message-ID: | 526EF8DF.8080705@enova.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 10/28/13 6:13 PM, Tom Lane wrote:
> Jim Nasby <jnasby(at)enova(dot)com> writes:
>> I've been working on trying to normalize a table that's got a bunch of text fields. Normalizing the first 4 has been a non-issue. But when I try and normalize 2 additional fields a bunch of query plans go belly-up.
>
> Try increasing join_collapse_limit/from_collapse_limit. I'm a bit
> confused by your description but I think maybe you've got more than 8
> relations in the subqueries.
Hell, never thought about that. Bumping it up did the trick. Thanks!
--
Jim Nasby, Lead Data Architect (512) 569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2013-10-29 14:10:43 | Re: Problems with hash join over nested loop |
| Previous Message | Tom Lane | 2013-10-28 23:13:55 | Re: Problems with hash join over nested loop |