Re: "Keyed" sequence? - Mailing list pgsql-general

From Israel Brewster
Subject Re: "Keyed" sequence?
Date
Msg-id AC2065E0-1F2D-4C45-8DE0-A48432F2FCFE@ravnalaska.net
Whole thread Raw
In response to Re: "Keyed" sequence?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On Apr 28, 2016, at 11:21 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Thu, Apr 28, 2016 at 12:09 PM, Israel Brewster <israel@ravnalaska.net> wrote:

>
> It'll kill your performance, but if aesthetics are that important to you...

They're not *that* important. I was just asking if there was a way to do this easily.

​While the performance argument might be true it is heavily dependent upon concurrency.  I'm doubting a PO system in the typical company has enough concurrency, and is sensitivity enough to small delays,​
 
​that giving up the benefit of sequential numbering would be a worthwhile trade-off.

I'm thinking the same - especially considering that we aren't exactly a huge company.


David J.

-----------------------------------------------
Israel Brewster
Systems Analyst II
Ravn Alaska
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7293
-----------------------------------------------

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: "Keyed" sequence?
Next
From: Berend Tober
Date:
Subject: Re: "Keyed" sequence?