db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

A read sets all-visible without VACUUM

After VACUUM the page is all-visible. An UPDATE clears the bit. In 19 a plain SELECT can prune the dead versions and set the bit again.

task

Update 10 rows, read the table once, then show all_visible of block 0.

hints