Re: Proposal: GetOldestXminExtend for ignoring arbitrary vacuum flags

From: "Seki, Eiji" <seki(dot)eiji(at)jp(dot)fujitsu(dot)com>
To: 'Simon Riggs' <simon(at)2ndquadrant(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: Proposal: GetOldestXminExtend for ignoring arbitrary vacuum flags
Date: 2017-02-28 00:25:41
Message-ID: A11BD0E1A40FAC479D740CEFA373E203396AAE03@g01jpexmbkw05
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 from WOS to ROS never modify (but only read) indexed table and modify only an index relation. And I think such a process that modifies some tables should not ignore analyze processes.

--
Regards,
Eiji Seki
Fujitsu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2017-02-28 00:27:30 Re: Creation of "Future" commit fest, named 2017-07
Previous Message David Steele 2017-02-28 00:25:32 PATCH: Make pg_stop_backup() archive wait optional