From: | AP <ap(at)zip(dot)com(dot)au> |
---|---|
To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pgsql 10: hash indexes testing |
Date: | 2017-08-10 10:41:37 |
Message-ID: | 20170810104137.ejkvzm6yp2vnga24@zip.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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)
mdstash=# select 5148912.0/158/8;
?column?
-----------------------
4073.5063291139240000
(1 row)
The index is 135GB rather than 900GB (from memory/give or take).
I'm happy so far. I'll be seeing how much more I can dump into it this weekend. :)
Thanks muchly to the both of you. :)
AP
From | Date | Subject | |
---|---|---|---|
Next Message | Jeevan Ladhe | 2017-08-10 10:56:12 | Re: Default Partition for Range |
Previous Message | Oliver Ford | 2017-08-10 10:21:21 | Fix number skipping in to_number |