| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Matthew Wakeling <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: merge join killing performance |
| Date: | 2010-05-28 02:46:21 |
| Message-ID: | AANLkTinBVZmcknJjIQGr_suUnlOoBE8uxG-vGfiA7KWQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Thu, May 27, 2010 at 7:16 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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?
>
> I've committed a patch for this, if you're interested in testing that
> it fixes your situation.
Cool, do we have a snapshot build somewhere or do I need to get all
the extra build bits like flex or yacc or bison or whatnot?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-05-28 02:47:57 | Re: tsvector pg_stats seems quite a bit off. |
| Previous Message | Fujii Masao | 2010-05-28 02:42:50 | Re: quoting and recovery.conf |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-05-28 02:56:12 | Re: merge join killing performance |
| Previous Message | Mark Wong | 2010-05-28 01:24:17 | hp hpsa vs cciss driver |