Re: [GENERAL] Modified rows are not marked as dead and as such vacuum is unable to clean them up

2017-07-06 Thread Tom Lane
=?UTF-8?B?VGFtw6FzIEFuZHLDoXMgS8OhbG3DoW4=?= writes: > we have a PostgreSQL 9.3.4 database with multiple large tables, that keep > growing. > Looking at the pg_stat of the front runner table that is currently about 1 > Gb big, it seems, that stale row data is not marked

[GENERAL] Modified rows are not marked as dead and as such vacuum is unable to clean them up

2017-07-06 Thread Tamás András Kálmán
Hello Dear List, This is my first post here. we have a PostgreSQL 9.3.4 database with multiple large tables, that keep growing. Looking at the pg_stat of the front runner table that is currently about 1 Gb big, it seems, that stale row data is not marked as dead after updates, the number of