Re: VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches)

[Christophe Pettus]

> On Feb 1, 2023, at 10:45, David G. Johnston <david.g.johns...@gmail.com> 
> wrote:
> The system just isn't that intelligent for "sequential scan", instead it does 
> literally what the label says, goes through the table one page at a time and 
> returns any live rows it finds. 

Although this does raise a question: Couldn't it skip pages that are marked 
appropriately in the visibility map?