Horton

Re: pgsql 10: hash indexes testing

Jeff Janes <jeff.janes@gmail.com>

View thread View on postgr.es
From: Jeff Janes <jeff.janes@gmail.com>
To: AP <ap@zip.com.au>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2017-07-05T03:23:20Z
Lists: pgsql-hackers 
On Tue, Jul 4, 2017 at 3:57 AM, AP <ap@zip.com.au> wrote:

>
> The data being indexed is BYTEA, (quasi)random and 64 bytes in size.
> The table has over 2 billion entries. The data is not unique. There's
> an average of 10 duplicates for every unique value.
>

What is the number of duplicates for the most common value?

Cheers,

Jeff

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