Re: [GENERAL] BDR Error restarted

2015-01-20 Thread Andres Freund
Hi, On 2015-01-13 02:43:26 -0700, deans wrote: > Hi Craig, any insight on this issue? :) You've, afaics, not posted your configuration. Could you do so? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training &

Re: [GENERAL] Update table is much faster after copying it

2015-01-20 Thread Andreas Kretschmer
Miles Jordan wrote: > Hi, > > I have tables a and b each with around 12 million rows. I am running > an update query to set the id of table b as an attribute of table a, > and have an appropriate index on table b that EXPLAIN tells me should > be used. > > The query takes 6 hours on an AWS db.r

[GENERAL] Update table is much faster after copying it

2015-01-20 Thread Miles Jordan
Hi, I have tables a and b each with around 12 million rows. I am running an update query to set the id of table b as an attribute of table a, and have an appropriate index on table b that EXPLAIN tells me should be used. The query takes 6 hours on an AWS db.r3.4xlarge. That seemed hugely excess

Re: [GENERAL] BDR Error restarted

2015-01-20 Thread deans
:( not yet, still having the issue. -- View this message in context: http://postgresql.nabble.com/BDR-Error-restarted-tp5833139p5834821.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch

Re: [GENERAL] asynchronous commit

2015-01-20 Thread Andreas Kretschmer
Robert DiFalco wrote: > Andreas, I think UNLOGGED would be something different but I'm not totally > clear. However, it seems to me that an unlogged table would simply disappear > (be truncated) after a server crash. That means instead of maybe loosing a > record or two that I could loose a ton o

Re: [GENERAL] BDR Error restarted

2015-01-20 Thread agent
Hi Dean Did you manage do get any help. I am having the exact issue at the moment. -- View this message in context: http://postgresql.nabble.com/BDR-Error-restarted-tp5833139p5834722.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mail