Re: BDR Global Sequences

Hi,

On 2014-09-29 13:52:52 -0700, pbj(at)cmicdo(dot)com wrote:
> 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.

> 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

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services