Re: Regarding ambulkdelete, amvacuumcleanup index methods

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: Regarding ambulkdelete, amvacuumcleanup index methods
Дата
Msg-id CAD21AoB_4mxcGP5MKxx9Y-r=AQWd+cnzkE8yg1fpEwd4iQmtjw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Regarding ambulkdelete, amvacuumcleanup index methods  (Abinaya k <abinaya.k.496@gmail.com>)
Список pgsql-hackers
On Thu, Jan 25, 2018 at 5:53 PM, Abinaya k <abinaya.k.496@gmail.com> wrote:
> Thanks for your response.
>
> Hope those stats will be used by Query Planner.
>
> So, just for my understanding, if i don't return stats (returning NULL from
> index_bulk_delete and index_vacuum_cleanup functions), Query Planner will
> not consider my Index as part of Query Path, beyond that i don't expect any
> bad consequences.

IIUC, the query planner doesn't ignore such indexes even if these values are 0.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Enhance pg_stat_wal_receiver view to display connected host
Следующее
От: Amit Langote
Дата:
Сообщение: Re: unique indexes on partitioned tables