Re: Regarding ambulkdelete, amvacuumcleanup index methods - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: Regarding ambulkdelete, amvacuumcleanup index methods
Date
Msg-id CAD21AoB_4mxcGP5MKxx9Y-r=AQWd+cnzkE8yg1fpEwd4iQmtjw@mail.gmail.com
Whole thread Raw
In response to Re: Regarding ambulkdelete, amvacuumcleanup index methods  (Abinaya k <abinaya.k.496@gmail.com>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Enhance pg_stat_wal_receiver view to display connected host
Next
From: Amit Langote
Date:
Subject: Re: unique indexes on partitioned tables