Re: [WIP] showing index maintenance on EXPLAIN

Поиск
Список
Период
Сортировка
Искать
От
Haribabu Kommi
Тема
Re: [WIP] showing index maintenance on EXPLAIN
Дата
Msg-id
CAJrrPGdMFRzgb_ZYDYzoR6Xdh8hNfEV0pVWj9W5GkPzuQkCC4g@mail.gmail.com
Ответ на
Список
Дерево обсуждения
[WIP] showing index maintenance on EXPLAIN Jaime Casanova <jaime@2ndquadrant.com>
Re: [WIP] showing index maintenance on EXPLAIN Thom Brown <thom@linux.com>
Re: [WIP] showing index maintenance on EXPLAIN Amit Kapila <amit.kapila16@gmail.com>
Re: [WIP] showing index maintenance on EXPLAIN Jaime Casanova <jaime@2ndquadrant.com>
Re: [WIP] showing index maintenance on EXPLAIN Robert Haas <robertmhaas@gmail.com>
Re: [WIP] showing index maintenance on EXPLAIN David G Johnston <david.g.johnston@gmail.com>
Re: [WIP] showing index maintenance on EXPLAIN Jaime Casanova <jaime@2ndquadrant.com>
Re: [WIP] showing index maintenance on EXPLAIN Amit Kapila <amit.kapila16@gmail.com>
Re: [WIP] showing index maintenance on EXPLAIN Jaime Casanova <jaime@2ndquadrant.com>
Re: [WIP] showing index maintenance on EXPLAIN Haribabu Kommi <kommi.haribabu@gmail.com>
On Thu, May 8, 2014 at 10:00 AM, Jaime Casanova  wrote:
> Hi,
>
> This patch implements $subject only when ANALYZE and VERBOSE are on.
> I made it that way because for years nobody seemed interested in this
> info (at least no one did it) so i decided that maybe is to much
> information for most people (actually btree indexes are normally very
> fast).
>
> But because we have GiST and GIN this became an interested piece of
> data (there are other cases even when using btree).
>
> Current patch doesn't have docs yet i will add them soon.

This patch provides the Insertion time of an index operation.
This information is useful to the administrator for reorganizing the indexes
based on the insertion time.

Quick review:

Applies to Head.
Regress test is passed.
Coding is fine.

Minor comments:

There is no need of printing the index insertion time as zero in case
of hot update operations.
Please correct the same.

Add the documentation changes.

Regards,
Hari Babu
Fujitsu Australia


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Michael Paquier
Дата:
FAQ