Horton

Re: pgsql 10: hash indexes testing

AP <ap@zip.com.au>

View thread View on postgr.es
From: AP <ap@zip.com.au>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2017-08-06T06:32:29Z
Lists: pgsql-hackers 
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.

AP

Commits

  1. pgstatindex: Insert some casts to prevent overflow.

  2. hash: Immediately after a bucket split, try to clean the old bucket.

  3. hash: Increase the number of possible overflow bitmaps by 8x.

  4. BRIN auto-summarization