vectorize_engine
vectorize_engine copied to clipboard
zhangh43
``` Konstantin wrote: Parallel scan is scattering pages between parallel workers. To fill VectorTupleSlot with data you may need more than one page (unless you make a decision that it...
Datum is general, but not optimized for performance. In vectorized engine, vtype is a column batch which contain values of the same type(int2, float4 etc.). If we store it as...
Current batchsize is 1024, while vops reported 64 is better. Let's have a performance test on it. ``` Konstantin wrote: Have you experimented with different batch size? I have done...
Throwing errors, i.e. elog(ERROR,...), is not safe in Postgres and may lead to resource leak. Better to return error code in plan_tree_mutator and propagate this error upstairs ``` Konstantin wrote:...
Discussed in Pg-hackers, always replace SeqScan with vectorized CustomScan may not always make sense, especially for OLTP queries. It's better to introduce cost to determine whether to replace. Here are...