| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Matthew Wakeling <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: merge join killing performance |
| Date: | 2010-05-20 14:28:12 |
| Message-ID: | 3829.1274365692@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> So, Tom, so you think it's possible that the planner isn't noticing
> all those nulls and thinks it'll just take a row or two to get to the
> value it needs to join on?
Could be. I don't have time right now to chase through the code, but
that sounds like a plausible theory.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-05-20 14:35:37 | Re: merge join killing performance |
| Previous Message | Stefan Kaltenbrunner | 2010-05-20 13:26:24 | Re: Renaming '2010-Next' to '2010-6' in the commitfest app |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2010-05-20 14:35:37 | Re: merge join killing performance |
| Previous Message | Krzysztof Nienartowicz | 2010-05-20 14:00:03 | Query causing explosion of temp space with join involving partitioning |