Andrei Lepikhov
Andrei Lepikhov
Currently iti is "frozen" mode can be used after learning stage. In this mode AQO don't write any data into database except of the aqo.force_collect_stat GUC set to true;
We have replaced table storage by file storage - the same idea as in pg_stat_statements.
I had some problem too. See https://github.com/danolivo/jo-bench - here I uploaded all csv files and made simple scripts to deploy the benchmark.
13.11.2019 04:29, Craig Ringer пишет: > @tvondra Any thoughts on picking these up? > I'm considering adopting this and making it tolerant of different Pg > versions. +1. I use...
Ну, пока тесты не проходит, вливать нечего
In AQO 1.5 we store data in db files. Such a decision has some reasons - for example, we avoid sanity check problems of some security applications. But main point...
This extension needs some additional hooks in the PG Core, so you can apply a patch. For PG13 you should use the stable13 branch and patch file named "aqo_pg13.patch". Because...
Thanks for your answer! > Timescaledb extension didn't consider our index scans for ordered append plans if index scan keys were not matching query keys, it would assume that index...
Yes, as for me, LIMIT over MergeAppend is the most profitable case for this feature in vanilla Postgres (in my mind, it may be coupled with merge join somehow). In...