At 19:32 03/08/2011, you wrote:
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.
Yes, this is what happened to me 2-3 years ago. Table had only 1-3
rows but its size is 80-90 Gb. Once the app quits, autovacuum cleaned
the table and became 8KB
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
