Re: [GENERAL] Replicating hundreds of thousandw of rows

2016-11-25 Thread Moreno Andreo
Il 25/11/2016 15:23, Job ha scritto: Hello, Hello, we are using rybyrep with postgresql 9.1 and 9.5 to have (almost-) real time synchronization for 5 years ATM. Unfortunately, it seems a dead project, so we had to find a good JRuby developer to make some customizations. we need to replicate hu

Re: [GENERAL] Replicating hundreds of thousandw of rows

2016-11-25 Thread Simon Riggs
On 25 November 2016 at 06:23, Job wrote: > Hello, > > we need to replicate hundreds of thousands of rows (for reporting) between > Postgresql Database nodes that are in different locations. > > Actually, we use Rubyrep with Postgresql 8.4.22. 8.4 is now end-of-life. You should move to the latest

[GENERAL] Replicating hundreds of thousandw of rows

2016-11-25 Thread Job
Hello, we need to replicate hundreds of thousands of rows (for reporting) between Postgresql Database nodes that are in different locations. Actually, we use Rubyrep with Postgresql 8.4.22. It works fine but it is very slow with a massive numbers of rows. With Postgresql 9.x, are there some way