On Thu, Aug 10, 2017 at 4:11 PM, AP <a...@zip.com.au> wrote: > On Sun, Aug 06, 2017 at 04:32:29PM +1000, AP wrote: >> On Sat, Aug 05, 2017 at 04:41:24PM +0530, Amit Kapila wrote: >> > > (On another note, I committed these patches.) >> > >> > Thanks. >> >> Seconded. :) >> >> Now uploading data with fillfactor of 90. I'll know in 2-3 days >> if the new patches are successful (earlier if they did not help). >> >> I compiled (as apt.postgresql.org does not provide the latest >> beta3 version for stretch; only sid which has a different perl >> version) 10~beta3~20170805.2225-1~593.git0d1f98b. > > Have gotten success with a dataset that failed before with ff 10. > > End result: > > 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. -- 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