Re: "Keyed" sequence?

From: Israel Brewster <israel(at)ravnalaska(dot)net>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Vik Fearing <vik(at)2ndquadrant(dot)fr>, "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: "Keyed" sequence?
Date: 2016-04-28 19:29:52
Message-ID: AC2065E0-1F2D-4C45-8DE0-A48432F2FCFE@ravnalaska.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Apr 28, 2016, at 11:21 AM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Thu, Apr 28, 2016 at 12:09 PM, Israel Brewster <israel(at)ravnalaska(dot)net <mailto:israel(at)ravnalaska(dot)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
-----------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Berend Tober 2016-04-28 22:57:02 Re: "Keyed" sequence?
Previous Message David G. Johnston 2016-04-28 19:21:19 Re: "Keyed" sequence?