Re: Yet another vectorized engine

I have done some performance comparisons.
First of all I failed to run vectorized version of Q1 with master branch
of your repository and
PG9_6_STABLE branch of Postgres:

NOTICE:  query can't be vectorized
DETAIL:  Non plain agg is not supported

I have to switch to pg96 branch.

Results (seconds) of Q1 execution are the  following:

max_parallel_workers_per_gather
PG9_6, enable_vectorize_engine=off
PG9_6, enable_vectorize_engine=on
master (jit=on)
0
36
20
10
4
10
-
5

I failed to run parallel version of Q1 with enable_vectorize_engine=on
because of the same error: "Non plain agg is not supported"

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.

--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company