Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 30 Jan 2007 22:55:19 -0300
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
- Follow-Ups:
- Re: VACUUM and open transactions
- From: Joseph S
- Re: VACUUM and open transactions
- References:
- Re: VACUUM and open transactions
- From: Joseph S
- Re: VACUUM and open transactions
- Prev by Date: Re: VACUUM and open transactions
- Next by Date: Re: Any Plans for cross database queries on the same server?
- Previous by thread: Re: VACUUM and open transactions
- Next by thread: Re: VACUUM and open transactions
- Indexes: