Re: Using indices for UNION.

From: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Using indices for UNION.
Date: 2014-01-14 09:10:40
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

This is cont'd from CF3.

The issue in brief is that UNION is never flattened differently
to UNION ALL so UNION cannot make use of index scan even if

This patch flattens UNION likewise currently did for UNION ALL.

This patch needs another 'UNION ALL' patch and further gain with
even another 'Widening application of indices' patch. ('Ready for
Commit' now in CF3..)

You can see the detailed outlines in the message at here,

The attached patche is rebased to current 9.4dev HEAD and make
check at the topmost directory and src/test/isolation are passed
without error.


Kyotaro Horiguchi
NTT Open Source Software Center

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2014-01-14 09:11:28 Re: Linux kernel impact on PostgreSQL performance
Previous Message Kyotaro HORIGUCHI 2014-01-14 09:08:10 Re: Get more from indices.