BDR Global Sequences - Mailing list pgsql-general

From pbj@cmicdo.com
Subject BDR Global Sequences
Date
Msg-id 1412023972.4918.YahooMailBasic@web161705.mail.bf1.yahoo.com
Whole thread Raw
Responses Re: BDR Global Sequences  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-general
I have a question about BDR Global Sequences.

I've been playing with BDR on PG 9.4beta2, built from source from the
2nd Quadrant GIT page (git://git.postgresql.org/git/2ndquadrant_bdr.git).

When trying a 1000000 row \copy-in, letting PG choose the global sequence
values, I get "ERROR:  could not find free sequence value for global
sequence public.myseq", as documented...no surprise there.  However, the
number of rows I can load before the error varies wildly with each trial.

Is there way to increase a global sequence's reservation block for each
node so that I can tell the nodes, "I'm going to load 100M rows now so
you should get ready for that."?

PJ



pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: PG 9.3 Switch streaming to wal shipping
Next
From: Andy Colson
Date:
Subject: Re: PG 9.3 Switch streaming to wal shipping