Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] pgsql 10: hash indexes testing - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: [HACKERS] pgsql 10: hash indexes testing
Date
Msg-id CAMkU=1x=58kS8-P6u60SK4LD1j=88ZLYzyOtZahcpM6K0gvD7A@mail.gmail.com
Whole thread Raw
In response to [HACKERS] pgsql 10: hash indexes testing  (AP <ap@zip.com.au>)
Responses Re: [HACKERS] pgsql 10: hash indexes testing
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS] pgsql 10: hash indexes testing
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Error while copying a large file in pg_rewind