Re: Why did my PostgreSQL tables double in size?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Why did my PostgreSQL tables double in size?
Дата
Msg-id CANzqJaAnD+FYYsxRQv0Mgqymu85MyeOOyXqn6-RsctpMC5z+WQ@mail.gmail.com
обсуждение исходный текст
Ответ на Why did my PostgreSQL tables double in size?  (Abdullah Ergin <abdullaherginwork@gmail.com>)
Ответы Re: Why did my PostgreSQL tables double in size?  (Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>)
Список pgsql-admin
Дерево обсуждения
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?
 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Yee Yee ( 舒兰）
Дата:
Сообщение: Re: GSSAPI authentication on Redhat8 and PostgreSQL15/16
Следующее
От: Yee Yee ( 舒兰）
Дата:
Сообщение: Re: GSSAPI authentication on Redhat8 and PostgreSQL15/16