Skip site navigation (1) Skip section navigation (2)

Re: VACUUM and open transactions

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Joseph S <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM and open transactions
Date: 2007-01-31 01:55:19
Message-ID: 20070131015519.GD2178@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-general
Joseph S wrote:
> I realize this thread is old, but I just conducted an experiment with pg 
> 8.0.10 and a transaction with a SERIALIZABLE isolation level does 
> prevent VACUUM from reclaiming rows that were created and then obsoleted 
>  in a subsequent transaction.

Right.  This is expected.  VACUUM cannot remove them because the
serializable transaction might still want to see those rows.  (I am
assuming the serializable transaction is still running when the vacuum
starts.  If that's not the case, please explain better).

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-general by date

Next:From: Joshua D. DrakeDate: 2007-01-31 02:15:01
Subject: Re: Any Plans for cross database queries on the same server?
Previous:From: Joseph SDate: 2007-01-31 01:15:19
Subject: Re: VACUUM and open transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group