Postgres Pro
Downloads
Home   >   mailing lists

Re: Can dml realize the partition table's rule and make good execution plan? - Mailing list pgsql-general

From Tom Lane
Subject Re: Can dml realize the partition table's rule and make good execution plan?
Date
Msg-id 12905.1352730024@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can dml realize the partition table's rule and make good execution plan?  (Craig Ringer <craig@2ndQuadrant.com>)
List pgsql-general
Tree view 
Craig Ringer <craig@2ndQuadrant.com> writes:
> It'd be really interesting to enhance the query planner to be smarter
> about this particular case,

At least for this particular example, it's not at all clear to me that
it'd be worth the cost.  Getting rid of accesses to tables altogether is
worthwhile, but avoiding one very-low-cost arm of a BitmapOr is less so.

            regards, tom lane

pgsql-general by date:

Previous
From: Chris Angelico
Date:
Subject: Re: integer instead of 'double precision'?
Next
From: Shaun Thomas
Date:
Subject: PSA: XFS and Linux Cache Poisoning