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