Re: sequences w/o holes

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: Marian Naghen <naghen(at)ratb(dot)ro>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: sequences w/o holes
Date: 2005-12-19 09:26:55
Message-ID: 678D9BFA-E653-4CE1-8516-3EB59B1EF2BA@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 19.12.2005, at 12:14 Uhr, Marian Naghen wrote:

> Can anyones suggest some readings about implementing
> sequences w/o holes ?

Question: why?

I doubt that this is possible without heavy locking, which kills your
performance.

cug

--
PharmaLine Essen, GERMANY and
Big Nerd Ranch Europe - PostgreSQL Training, Feb. 2006, Rome, Italy
http://www.bignerdranch.com/classes/postgresql.shtml

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marian Naghen 2005-12-19 09:39:11 sequences in transaction blocks
Previous Message Michael Glaesemann 2005-12-19 09:21:58 Re: sequences w/o holes