Re: Can dml realize the partition table's rule and make good execution plan?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig Ringer <craig(at)2ndQuadrant(dot)com>
Cc: 高健 <luckyjackgao(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Can dml realize the partition table's rule and make good execution plan?
Date: 2012-11-12 14:20:24
Message-ID: 12905.1352730024@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig Ringer <craig(at)2ndQuadrant(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2012-11-12 14:28:33 Re: PostgreSQL and a clustered file system
Previous Message Chris Angelico 2012-11-12 13:39:34 Re: integer instead of 'double precision'?