On Sun, Jun 17, 2018 at 9:22 PM, Andrew Gierth <and...@tao11.riddles.org.uk> wrote: >>>>>> "Tom" == Tom Lane <t...@sss.pgh.pa.us> writes: > > Tom> 2. Although _bt_killitems doesn't WAL-log its setting of kill > Tom> bits, those bits could propagate to the standby anyway, as a > Tom> result of a subsequent WAL action on the index page that gets a > Tom> full-page image added. > > That's OK as long as we're ignoring those hints on the standby. >
What if we don't ignore those hints on standby for a specific case like the one in get_actual_variable_range? Now, if the user has enabled wal_log_hints on the master, it could save time from scanning many dead tuples on standby. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com