On 08/06/2013 01:56 PM, Vlad Arkhipov wrote: > Hello, > > We are suffering from a long-standing issue with autovacuuming/vacuuming > system catalogs on the production server. We are actively using > temporary tables in the legacy application, so system catalogs grows > unbounded in time. Autovacuum does not remove dead tuples and neither do > the manual vacuum. We are running PostgreSQL 9.2.4 on Linux 2.6.18 x86_64. > > Nobody's holding an open transaction for long periods.
Got any prepared transactions? SELECT * FROM pg_prepared_xacts; SHOW max_prepared_transactions; -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers