vacuum on table with all rows frozen - Mailing list pgsql-general

From Tom DalPozzo
Subject vacuum on table with all rows frozen
Date
Msg-id CAK77FCTeB3EcPwJxxUk9R+5SbFqR-Ph5LNqexHfRim2x1kSY_w@mail.gmail.com
Whole thread Raw
Responses Re: vacuum on table with all rows frozen  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi,
let's suppose I have a table which after beign populated with only INSERTs, doesn't receive no more writing queries (neither insert or update or delete). Only reading queries.
Once all table rows get frozen by (auto)vacuum, will a next (auto)vacuum scan that table for any reason or does it understand that it would be useless (as no more rows to mark as forzen and no dead tuples) ?
As I will have hunderds of big tables like that, I want to be sure that the vacuum process doesn't waste time.
Regards
Pupillo




pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Keycloak and Postgres
Next
From: Adrian Klaver
Date:
Subject: Re: vacuum on table with all rows frozen