Re: CRC32 function

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Ilia Kantor <ilia(at)obnovlenie(dot)ru>, pgsql-patches(at)postgresql(dot)org
Subject: Re: CRC32 function
Date: 2005-08-25 22:34:19
Message-ID: 200508252234.j7PMYJk08997@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Bruno Wolff III wrote:
> On Thu, Aug 25, 2005 at 16:14:04 -0400,
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
> > Ilia Kantor wrote:
> > > Both backend and users may have a nice use of the function.
> > >
> > >
> > >
> > > Nice and fast hashing when one doesn't need encryption.
> >
> > We already have MD5 encryption in the server. Why would someone want
> > CRC32?

True, but if there are several million rows, a 32-bit CRC isn't really
useful (too many collisions). I can see it useful in a few cases, but
not for general usefulness.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-08-25 22:44:13 Re: CRC32 function
Previous Message Tom Lane 2005-08-25 22:15:46 Re: [HACKERS] Proposed patch to getaddrinfo.c to support