Re: pgsql 10: hash indexes testing

On Mon, Aug 14, 2017 at 6:10 AM, AP <ap(at)zip(dot)com(dot)au> wrote:
> On Fri, Aug 11, 2017 at 07:33:51AM +0530, Amit Kapila wrote:
>> On Thu, Aug 10, 2017 at 4:11 PM, AP <ap(at)zip(dot)com(dot)au> wrote:
>> > mdstash=# select * from pgstathashindex('link_datum_id_idx');
>> > version | bucket_pages | overflow_pages | bitmap_pages | unused_pages | live_items | dead_items | free_percent
>> > ---------+--------------+----------------+--------------+--------------+------------+------------+------------------
>> > 4 | 12391325 | 5148912 | 158 | 191643 | 4560007478 | 0 | 1894.29056075982
>> > (1 row)
>>
>> The free_percent calculation seems to be wrong. Can you please once
>> try after recent commit 0b7ba3d6474b8f58e74dba548886df3250805cdf? I
>> feel this should be fixed by that commit.
>
> Sorry I couldn't get to help you debugging this myself. Work got annoying. :/
>
> That said, I think that this is the first time that I've seen the value be
> under 100:
>

Thanks for confirming the same.

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com