vacuum on table with all rows frozen

From: Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: vacuum on table with all rows frozen
Date: 2017-04-01 16:09:37
Message-ID: CAK77FCTeB3EcPwJxxUk9R+5SbFqR-Ph5LNqexHfRim2x1kSY_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2017-04-01 16:34:17 Re: vacuum on table with all rows frozen
Previous Message Bill Moran 2017-04-01 10:57:20 Re: Keycloak and Postgres