Postgres Pro
Downloads
Home   >   mailing lists

VACUUM and open transactions - Mailing list pgsql-general

From Joseph Shraibman
Subject VACUUM and open transactions
Date
Msg-id eh8mj9$2uq8$1@news.hub.org
Whole thread Raw
Responses Re: VACUUM and open transactions
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: "Leonel Nunez"
Date:
Subject: Re: Ubuntu Help
Next
From: Martijn van Oosterhout
Date:
Subject: Re: VACUUM and open transactions