Re: On columnar storage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: On columnar storage
Date: 2015-06-14 18:01:16
Message-ID: 12326.1434304876@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> Tom Lane wrote:
>> Actually ... if you intend to allow column storage to work with inherited
>> tables (and if you don't, you'd better have a darn good reason why not),
>> I think you probably want to do this join insertion *after* inheritance
>> expansion, so you can join child column stores only to the appropriate
>> child heap table, and not to the entire inheritance tree.

> Won't this cause issues to MergeAppend optimizations?

Like what? And if there are such issues, why do you think you wouldn't
be expected to solve them?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2015-06-14 18:07:16 Git humor
Previous Message Alvaro Herrera 2015-06-14 17:54:27 Re: On columnar storage