> 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?
- Re: SELECT * FROM huge_table LIMIT 10; Why does i... Dimitrios Apostolou
- Re: SELECT * FROM huge_table LIMIT 10; Why do... Christophe Pettus
- Re: SELECT * FROM huge_table LIMIT 10; Why does it tak... Tom Lane
- Re: SELECT * FROM huge_table LIMIT 10; Why does i... David G. Johnston
- Re: SELECT * FROM huge_table LIMIT 10; Why do... Dimitrios Apostolou
- Re: SELECT * FROM huge_table LIMIT 10; Wh... David G. Johnston
- Re: SELECT * FROM huge_table LIMIT 10; Why does i... Dimitrios Apostolou
- VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table L... Dimitrios Apostolou
- Re: VACUUM vs VACUUM FULL (was: SELECT * FROM hug... David G. Johnston
- Re: VACUUM vs VACUUM FULL (was: SELECT * FROM... Christophe Pettus