=?UTF-8?B?VGFtw6FzIEFuZHLDoXMgS8OhbG3DoW4=?= <hello@xxxxxxxxxxxxxxx> 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 as dead after updates, Have you checked for uncommitted prepared transactions? If "select * from pg_prepared_xacts" finds anything, that's probably your problem. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
