On Mon, Aug 14, 2017 at 6:10 AM, AP <a...@zip.com.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 <a...@zip.com.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers