pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Why did my PostgreSQL tables double in size?
Date: Mon, 20 Nov 2023 10:22:04 +0200
Message-ID: <a57dd304-46ec-148c-8dc3-ddd9d413d8fa@cloud.gatewaynet.com> (raw)
In-Reply-To: <CANzqJaAnD+FYYsxRQv0Mgqymu85MyeOOyXqn6-RsctpMC5z+WQ@mail.gmail.com>
References: <CAJZxWEP2t4Fw+D=gwWMNboBZmCL3G58aZO+cyLn4jE-9n1qGEg@mail.gmail.com>
	<CANzqJaAnD+FYYsxRQv0Mgqymu85MyeOOyXqn6-RsctpMC5z+WQ@mail.gmail.com>


On 11/20/23 05:22, Ron Johnson wrote:
> On Sun, Nov 19, 2023 at 5:24 PM Abdullah Ergin 
> <abdullaherginwork@gmail.com> wrote:
>
>     During this period, I believe the unchecked increase in table size
>     was due to the auto vacuum parameter being turned off. What should
>     I do to prevent this from affecting the 12th month and beyond?
>
> Make sure not to comment out "autovacuum = on"?
>
> Create a cron job that regularly runs psql -Xtc "SHOW AUTOVACUUM", and 
> sends an email if it's set to off?

And be sure to check no table has unexpectedly individual autovacuum 
turned off :

select pg_class.oid::regclass,relkind, opts.* from pg_class JOIN LATERAL 
pg_options_to_table(reloptions) opts ON (true) where relkind not in 
('i','v','S') AND option_name ~* '.*autovacuum_enabled' AND 
option_value='false'

view thread (4+ messages)  latest in thread

Message-ID: <a57dd304-46ec-148c-8dc3-ddd9d413d8fa@cloud.gatewaynet.com>
Permalink:  ../a57dd304-46ec-148c-8dc3-ddd9d413d8fa@cloud.gatewaynet.com/
Also on:    postgresql.org/message-id/a57dd304-46ec-148c-8dc3-ddd9d413d8fa@cloud.gatewaynet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: a.mantzios@cloud.gatewaynet.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Why did my PostgreSQL tables double in size?
  In-Reply-To: <a57dd304-46ec-148c-8dc3-ddd9d413d8fa@cloud.gatewaynet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox