Re: BUG #13846: INSERT ON CONFLICT consumes sequencers on conflicts - Mailing list pgsql-bugs

From Thomas Kellerer
Subject Re: BUG #13846: INSERT ON CONFLICT consumes sequencers on conflicts
Date
Msg-id n6jppa$6kl$1@ger.gmane.org
Whole thread Raw
In response to Re: BUG #13846: INSERT ON CONFLICT consumes sequencers on conflicts  (Paul Hester <paul@salesintel.com>)
List pgsql-bugs
Paul Hester schrieb am 06.01.2016 um 06:04:
> This limitation, of consuming sequencers used for defaults on columns
> not necessary to resolve conflict, diminishes the viability for using
> Postges UPSERTS for large data warehouses, is all I'm saying (or
> requires surrogate keys being 64 bit). Just caught me by surprise in
> comparison to other RDBMSs offering some form of UPSERTs that would
> not consume a sequencer if its values weren't required to resolve
> conflicts.

Why does this "diminish" the viability of a sequence?

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #13846: INSERT ON CONFLICT consumes sequencers on conflicts
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_regress --help missing description of --bindir