VACUUM and open transactions

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: VACUUM and open transactions
Date: 2006-10-19 20:18:50
Message-ID: eh8mj9$2uq8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running postgres 8.0.8. I have a table that is updated very
rapidly, so I vacuum it every 10 minutes. The problem is that I
sometimes have transactions that hang out for a long time without doing
anything. These transactions are preventing VACUUM from cleaning up
tuples that were created and then deleted in transactions that started
way after the hanging one. Is there any way to fix this?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-10-19 20:22:36 Re: VACUUM and open transactions
Previous Message Leonel Nunez 2006-10-19 20:09:53 Re: Ubuntu Help