Re: Slow planning time for simple query

On Sun, Jun 17, 2018 at 9:22 PM, Andrew Gierth
 wrote:
>>>>>> "Tom" == Tom Lane  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