Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Re: Reuse seria...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 2 Topic 3048 of 3255
Post > Topic >>

Re: Reuse serial numbers?

by nobs@[EMAIL PROTECTED] (Emil Obermayr) Mar 27, 2008 at 11:54 AM

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.

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 2 Posts in Topic:
Re: Reuse serial numbers?
nobs@[EMAIL PROTECTED] (  2008-03-27 11:06:24 
Re: Reuse serial numbers?
nobs@[EMAIL PROTECTED] (  2008-03-27 11:54:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 13 2:21:18 CDT 2008.