On Fri, Apr 13, 2012 at 8:15 PM, Robert Haas <robertmh...@gmail.com> wrote: > That's probably true, but I'm not sure it's worth worrying about - > one-in-four-billion is a pretty small probability.
Is this not subject to the birthday paradox? If you have a given hash you're worried about a collision with then you have a one-in-four-billion chance. But if you have a collection of hashes and you're worried about any collisions then it only takes about 64k before there's likely a collision. -- greg -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
