Re: A design for amcheck heapam verification

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: A design for amcheck heapam verification
Date: 2017-09-29 18:01:26
Message-ID: CA+Tgmobz_UDJ9NWd74PMCaKZTMevYepJn01ptuL3E+aXBoHP9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 29, 2017 at 1:57 PM, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> On Fri, Sep 29, 2017 at 10:29 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> I am also wondering whether this patch should consider
>> 81c5e46c490e2426db243eada186995da5bb0ba7 as a way of obtaining
>> multiple hash values. I suppose that's probably inferior to what is
>> already being done on performance grounds, but I'll just throw out a
>> mention of it here all the same in case it was overlooked or the
>> relevance not spotted...
>
> Well, we sometimes only want one hash value. This happens when we're
> very short on memory (especially relative to the estimated final size
> of the set), so it's a fairly common requirement. And, we have a
> convenient way to get a second independent uint32 hash function now
> (murmurhash32()).

Right, so if you wanted to use the extended hash function
infrastructure, you'd just call the extended hash function with as
many different seeds as the number of hash functions you need. If you
need 1, you call it with one seed, say 0. And if you need any larger
number, well, cool.

Like I say, I'm not at all sure this is better than what you've got
right now. But it's an option.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nico Williams 2017-09-29 18:02:12 Re: COMMIT TRIGGERs, take n+1
Previous Message Robert Haas 2017-09-29 17:59:46 Re: pgbench stuck with 100% cpu usage