| From: | Hubert Zhang <hzhang(at)pivotal(dot)io> |
|---|---|
| To: | Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org, Gang Xiong <gxiong(at)pivotal(dot)io>, Asim R P <apraveen(at)pivotal(dot)io>, Ning Yu <nyu(at)pivotal(dot)io> |
| Subject: | Re: Yet another vectorized engine |
| Date: | 2020-02-12 10:12:36 |
| Message-ID: | CAB0yrenAoyT+ONeh9BKXWCdytYirbhgi+PKYCzz3CWUGv-x54A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Feb 11, 2020 at 1:20 AM Konstantin Knizhnik <
k(dot)knizhnik(at)postgrespro(dot)ru> wrote:
>
> So looks like PG-13 provides significant advantages in OLAP queries
> comparing with 9.6!
> Definitely it doesn't mean that vectorized executor is not needed for new
> version of Postgres.
> Once been ported, I expect that it should provide comparable improvement
> of performance.
>
> But in any case I think that vectorized executor makes sense only been
> combine with columnar store.
>
Thanks for the test. +1 on vectorize should be combine with columnar store.
I think when we support this extension
on master, we could try the new zedstore.
I'm not active on this work now, but will continue when I have time. Feel
free to join bring vops's feature into this extension.
Thanks
Hubert Zhang
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2020-02-12 10:22:26 | Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager |
| Previous Message | imai.yoshikazu@fujitsu.com | 2020-02-12 09:40:57 | RE: [Proposal] Add accumulated statistics for wait event |