| From: | pbj(at)cmicdo(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | BDR Global Sequences |
| Date: | 2014-09-29 20:52:52 |
| Message-ID: | 1412023972.4918.YahooMailBasic@web161705.mail.bf1.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Colson | 2014-09-29 21:17:23 | Re: PG 9.3 Switch streaming to wal shipping |
| Previous Message | Andy Colson | 2014-09-29 20:39:09 | PG 9.3 Switch streaming to wal shipping |