Skip site navigation (1) Skip section navigation (2)

Re: Reuse serial numbers?

From: nobs(at)nobswolf(dot)info (Emil Obermayr)
To: pgsql-novice(at)postgresql(dot)org
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Reuse serial numbers?
Date: 2008-03-27 10:54:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Thu, Mar 27, 2008 at 10:17:51AM +0000, A B wrote:
> Oh, I just thought of having a boolean field for indicating usage...I
> don't know if it will be more efficient. But as a novice... I think
> that will be sufficient.

Efficiency is alway a point of course. But you have to keep track of
your field and you create a redundant data structure. You might run into
inconsistancy with it.

"My" solution is self-consistant, not redundant and you don't need write
operations during seeking for the fre entry. So maybe its even more

In response to

pgsql-novice by date

Next:From: ashishDate: 2008-03-27 11:39:59
Subject: Re: Restoring DB using Continuous Archive Backup
Previous:From: nickDate: 2008-03-27 10:21:43
Subject: Restoring DB using Continuous Archive Backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group