On 08/03/11 10:21 AM, Eduardo Morras wrote:
One question, while you run your tests, does "IDLE IN TRANSACTION" messages happen? If you run your tests with a permanent connection to database, the tables are locked and autovacuum cannot work.
its not that tables are locked, its that vacuum (auto or otherwise) can't clear any tuples newer than the oldest active transaction.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
