Re: Plans for solving the VACUUM problem - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: Plans for solving the VACUUM problem
Date
Msg-id 007001c0e799$321dcc00$4a79583f@sectorbase.com
Whole thread Raw
In response to AW: Plans for solving the VACUUM problem  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
> Yes, that is a good description. And old version is only required in the following 
> two cases:
> 
> 1. the txn that modified this tuple is still open (reader in default committed read)
> 2. reader is in serializable transaction isolation and has earlier xtid
> 
> Seems overwrite smgr has mainly advantages in terms of speed for operations
> other than rollback.

... And rollback is required for < 5% transactions ...

Vadim




pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Regression tes for R-tree
Next
From: Hannu Krosing
Date:
Subject: Re: Plans for solving the VACUUM problem