Table : Bloat grow high

Поиск
Список
Период
Сортировка
От Alexis Zapata
Тема Table : Bloat grow high
Дата
Msg-id BLAPR19MB4626534A9D173ECE0F0A9521A1009@BLAPR19MB4626.namprd19.prod.outlook.com
обсуждение исходный текст
Ответы Re: Table : Bloat grow high
Re: Table : Bloat grow high
Список 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 по дате отправления: