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: 20080327105413.GC3898@nobswolf.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
efficient.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message ashish 2008-03-27 11:39:59 Re: Restoring DB using Continuous Archive Backup
Previous Message nick 2008-03-27 10:21:43 Restoring DB using Continuous Archive Backup