Thanks Keith and Ron. Now, I understood better.
Thanks,
Raj Kumar Narendiran.
On Thu, 8 Jul 2021, 20:29 Ron, <ronljohnsonjr@xxxxxxxxx> wrote:
On 7/8/21 8:38 AM, Keith Fiske wrote:
[snip]
> Vacuum also keeps the freespacemap and visibility maps updated as well.
> Not quite as critical for insert-only tables, but it can still influence
> query planning. Having an up to date visibility-map can help index-only
> scans happen more frequently if possible.
We've got INSERT-only tables, and the query planner only used sequential
scans (on a freshly loaded 6TB database) until I vacuumed all tables,
--
Angular momentum makes the world go 'round.
