Re: Problem with update on partitioned table - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with update on partitioned table
Date
Msg-id 3234.1206396307@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with update on partitioned table  (Alex Solovey <a.solovey@gmail.com>)
Responses Re: Problem with update on partitioned table  (Alex Solovey <a.solovey@gmail.com>)
List pgsql-general
Alex Solovey <a.solovey@gmail.com> writes:
> Thanks for the patch. We've tried it here, and it improved query plan
> slightly (indeed, it looks exactly like the plan from 8.2.6 now).
> But, as you've said, empty sub-joins are still not discarded, so query
> execution time did not improve. And this is the same in both 8.2 and 8.3.

If you're feeling brave, try the patch I just committed to CVS.

            regards, tom lane

pgsql-general by date:

Previous
From: Alex Solovey
Date:
Subject: Re: Problem with update on partitioned table
Next
From: Alex Solovey
Date:
Subject: Re: Problem with update on partitioned table