Re: Best approach for a "gap-less" sequence - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Best approach for a "gap-less" sequence
Date
Msg-id 87hd0bilrk.fsf@gmail.com
Whole thread Raw
In response to Re: Best approach for a "gap-less" sequence  ("Dawid Kuroczko" <qnex42@gmail.com>)
List pgsql-general
"Dawid Kuroczko" <qnex42@gmail.com> writes:

> I did not test the code right now, but I've written something similar to
> it some time ago, and it worked fine.  Remember to vacuum gapless_seq
> table frequently and don't expect stellar performance from it.

Interesting approach...  And I don't expect too much performance for it.  The
restriction of the gapless sequence makes it expected that there's some minor
delay somewhere.  It would be bad on "common" sequences, but not on
gapless. :-)

Thanks for the code...  It is a bit different from mine -- better, in
fact... ;-) -- and I could give it a try.

--
Jorge Godoy      <jgodoy@gmail.com>

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: VACUUM VERBOSE output to STDERR
Next
From: Jorge Godoy
Date:
Subject: Re: Best approach for a "gap-less" sequence