Re: [HACKERS] Proposal: GetOldestXminExtend for ignoring arbitraryvacuum flags - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: [HACKERS] Proposal: GetOldestXminExtend for ignoring arbitraryvacuum flags
Date
Msg-id CAA4eK1JWSDeviTnOXvmoQrFXQ9nAGt55cs7Zy3tbopFUGKMCqw@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Proposal: GetOldestXminExtend for ignoring arbitrary vacuum flags  ("Seki, Eiji" <seki.eiji@jp.fujitsu.com>)
List pgsql-hackers
On Tue, Feb 14, 2017 at 11:49 AM, Seki, Eiji <seki.eiji@jp.fujitsu.com> wrote:
> Hi all,
>
> I propose the patch that adds a function GetOldestXminExtended that is like GetOldestXmin but can ignore arbitrary
vacuumflags. And then, rewrite GetOldestXmin to use it. Note that this is done so as not to change the behavior of
GetOldestXmin.
>
> This change will be useful for features that only reads rows that are visible by all transactions and could not wait
specificprocesses (VACUUM, ANALYZE, etc...) for performance.
 
>

How will you decide just based on oldest xmin whether the tuple is
visible or not?  How will you take decisions about tuples which have
xmax set?

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Corey Huinker
Date:
Subject: Re: \if, \elseif, \else, \endif (was Re: [HACKERS] PSQL commands:\quit_if, \quit_unless)
Next
From: Tatsuo Ishii
Date:
Subject: [HACKERS] Sync message