Re: Slow planning time for simple query

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Slow planning time for simple query
Дата
Msg-id CAA4eK1+-kiNXzux4uoiyQr-s3HYgY=eMqovEzYPjrq_0G4-rgw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow planning time for simple query  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: Slow planning time for simple query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Sun, Jun 17, 2018 at 9:22 PM, Andrew Gierth
<andrew@tao11.riddles.org.uk> wrote:
>>>>>> "Tom" == Tom Lane <tgl@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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jeevan Chalke
Дата:
Сообщение: Re: Server crashed with TRAP: FailedAssertion("!(parallel_workers >0)" when partitionwise_aggregate true.
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Concurrency bug in UPDATE of partition-key