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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
