| From: | AP <ap(at)zip(dot)com(dot)au> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pgsql 10: hash indexes testing |
| Date: | 2017-07-05 09:31:40 |
| Message-ID: | 20170705093139.estahitvi64ql5oc@zip.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jul 04, 2017 at 08:23:20PM -0700, Jeff Janes wrote:
> On Tue, Jul 4, 2017 at 3:57 AM, AP <ap(at)zip(dot)com(dot)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?
Damn. Was going to collect this info as I was doing a fresh upload but
it fell through the cracks of my mind. It'll probably take at least
half a day to collect (a simple count(*) on the table takes 1.5-1.75
hours parallelised across 11 processes) so I'll probably have this in
around 24 hours if all goes well. (and I don't stuff up the SQL :) )
AP.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Khandekar | 2017-07-05 09:42:49 | Re: UPDATE of partition key |
| Previous Message | Michael Paquier | 2017-07-05 07:57:20 | Re: pg_stop_backup(wait_for_archive := true) on standby server |