Table : Bloat grow high

Поиск
Список
Период
Сортировка
От Alexis Zapata
Тема Table : Bloat grow high
Дата
Msg-id BLAPR19MB4626534A9D173ECE0F0A9521A1009@BLAPR19MB4626.namprd19.prod.outlook.com
обсуждение исходный текст
Ответы Re: Table : Bloat grow high  (Ron <ronljohnsonjr@gmail.com>)
Re: Table : Bloat grow high  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general

Hi all, 
In postgresql 13.5 I have a table (size 3.1 GB) and in this table occurs near to 200 updates per second, after 2 days the size table is 7 GB and bloat grow to 45% and 
 the query operations are degraded. vacuum runs every 5 seconds over this. but the bloat growth continues, to solve the 
problem quickly, we have made a replica of the table with a trigger, then a copy of the data and in a 
transaction we rename the table, but it would not be the best solution.
Some suggestion about stop this size increase or parameter to setting up?

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

Предыдущее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: pg_isready mandatory parameters?
Следующее
От: Jeffrey Walton
Дата:
Сообщение: Re: pg_isready mandatory parameters?