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>)
Список pgsql-hackers
On Thu, May 8, 2014 at 10:00 AM, Jaime Casanova <jaime@2ndquadrant.com> 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
Дата:
Сообщение: Re: replication commands and log_statements
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: replication commands and log_statements