BDR Global Sequences

[p***@cmicdo.com]

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

[Andres Freund]

Hi,

Post by p***@cmicdo.com
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.

Yea, it depends on how quick the refilling starts and how quickly it can
keep up. The next version hopefull will start to fill up a bit quicker.

Post by p***@cmicdo.com
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."?

Not yet, but we're planning to add that.

Greetings,

Andres Freund

[p***@cmicdo.com]

This post might be inappropriate. Click to display it.