Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Add pgstathashindex() to get hash index table statistics. - Mailing list pgsql-hackers

From Ashutosh Sharma
Subject Re: [HACKERS] Add pgstathashindex() to get hash index table statistics.
Date
Msg-id CAE9k0PkTtKFB3YndOyQMjwuHx+-FtUP1ynK8E-nHtetoow3NtQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Add pgstathashindex() to get hash index table statistics.  (Robert Haas <robertmhaas@gmail.com>)
Responses 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>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] parallel "return query" is no good
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Enabling parallelism for queries coming from SQL orother PL functions