| From: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
|---|---|
| To: | Abinaya k <abinaya(dot)k(dot)496(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Regarding ambulkdelete, amvacuumcleanup index methods |
| Date: | 2018-01-29 08:18:05 |
| Message-ID: | CAD21AoB_4mxcGP5MKxx9Y-r=AQWd+cnzkE8yg1fpEwd4iQmtjw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jan 25, 2018 at 5:53 PM, Abinaya k <abinaya(dot)k(dot)496(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2018-01-29 08:29:53 | Re: unique indexes on partitioned tables |
| Previous Message | Michael Paquier | 2018-01-29 08:06:16 | Re: Enhance pg_stat_wal_receiver view to display connected host |