Bharathy

Hi @mickael-choisnet Any UPDATE/DELETE on compressed chunk will result in decompressing(~2min) + update/delete. As part of compression policy job recompressing (~2min) + vacuum process (~3min) is done. Hope its clear...

Hi @mickael-choisnet Decompression happens only if there are rows which match the WHERE clause. Please check below. Second delete does nothing since all rows have already been deleted. If you...

Hi @mickael-choisnet Thanks for the testcase. You are right, unfortunately as of today, the WHERE predicate with simple conditions having const literals has the optimisation implemented. We have a PR...

Hi @mickael-choisnet Iam not sure when it will get prioritised. Definitely not in 2.11.1 or 2.