On Mon, Oct 26, 2009 at 4:30 PM, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>> Why aren't you satisfied with hashtext('foo') ?
> Collisions, mostly.
Why even bother with a hash function when you can just have multiple
table pull from a shared sequence? AFAICT, this solves the OP's
problem with no downsides (I used the approach with excellent results
in a ported cobol app which had pessimistic locking requirement).
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2009-10-27 14:01:01|
|Subject: Re: "toast.fillfactor" is documented but not recognized?|
|Previous:||From: Kenneth Marshall||Date: 2009-10-27 12:52:58|
|Subject: Re: Proposal: String key space for advisory locks|