Re: Why did my PostgreSQL tables double in size?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Abdullah Ergin <abdullaherginwork(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Why did my PostgreSQL tables double in size?
Date: 2023-11-20 03:22:51
Message-ID: CANzqJaAnD+FYYsxRQv0Mgqymu85MyeOOyXqn6-RsctpMC5z+WQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Nov 19, 2023 at 5:24 PM Abdullah Ergin <abdullaherginwork(at)gmail(dot)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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message 舒兰） <sweety.soul7@gmail.com> 2023-11-20 06:40:50 Re: GSSAPI authentication on Redhat8 and PostgreSQL15/16
Previous Message 舒兰） <sweety.soul7@gmail.com> 2023-11-20 02:18:55 Re: GSSAPI authentication on Redhat8 and PostgreSQL15/16