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

From Seki, Eiji
Subject Re: [HACKERS] Proposal: GetOldestXminExtend for ignoring arbitraryvacuum flags
Date
Msg-id A11BD0E1A40FAC479D740CEFA373E203396AAE03@g01jpexmbkw05
Whole thread Raw
In response to Re: [HACKERS] Proposal: GetOldestXminExtend for ignoring arbitraryvacuum flags  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
on 2017-02-24 04:41:09 Simon Riggs wrote:
> ...you didn't comment at all on the accuracy and usefulness of the
> gathered statistics, when the sample is biased towards non-updated
> data.

In my understanding, the sample for statistics is not biased at least in our use case because the conversion process
fromWOS to ROS never modify (but only read) indexed table and modify only an index relation. And I think such a process
thatmodifies some tables should not ignore analyze processes.
 

--
Regards,
Eiji Seki
Fujitsu




pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: [HACKERS] PATCH: Make pg_stop_backup() archive wait optional
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Creation of "Future" commit fest, named 2017-07