Re: [HACKERS] Add pgstathashindex() to get hash index table statistics.

Поиск
Список
Период
Сортировка
От Ashutosh Sharma
Тема Re: [HACKERS] Add pgstathashindex() to get hash index table statistics.
Дата
Msg-id CAE9k0PkTtKFB3YndOyQMjwuHx+-FtUP1ynK8E-nHtetoow3NtQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Add pgstathashindex() to get hash index table statistics.  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Add pgstathashindex() to get hash index table statistics.  (Amit Kapila <amit.kapila16@gmail.com>)
Re: Add pgstathashindex() to get hash index table statistics.  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi,

On Tue, Feb 7, 2017 at 9:23 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Mon, Feb 6, 2017 at 10:40 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>>> Maybe we should call them "unused pages".
>>
>> +1.  If we consider some more names for that column then probably one
>> alternative could be "empty pages".
>
> Yeah, but I think "unused" might be better.  Because a page could be
> in use (as an overflow page or primary bucket page) and still be
> empty.
>

Based on the earlier discussions, I have prepared a patch that would
allow pgstathashindex() to show the number of unused pages in hash
index. Please find the attached patch for the same. Thanks.

--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] parallel "return query" is no good
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Enabling parallelism for queries coming from SQL orother PL functions