Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-06 Thread Stephen Frost
Ivan, * Ivan Voras (ivo...@gmail.com) wrote: > I'm investigating options for an environment which has about a dozen > servers and several dozen databases on each, and they occasionally need to > run huge reports which slow down other services. This is of course "legacy > code". After some discussi

Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-06 Thread Rick Otten
I suggest SymmetricDS. ( http://symmetricds.org ) I've had good luck using them to aggregate data from a heterogeneous suite of database systems and versions back to a single back-end data mart for exactly this purpose. On Fri, Jan 6, 2017 at 2:24 PM, Ivan Voras wrote: > Hello, > > I'm inves

Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-06 Thread Ivan Voras
On 6 Jan 2017 8:30 p.m., "Scott Marlowe" wrote: On Fri, Jan 6, 2017 at 12:24 PM, Ivan Voras wrote: > Hello, > > I'm investigating options for an environment which has about a dozen servers > and several dozen databases on each, and they occasionally need to run huge > reports which slow down oth

Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-06 Thread Scott Marlowe
On Fri, Jan 6, 2017 at 12:24 PM, Ivan Voras wrote: > Hello, > > I'm investigating options for an environment which has about a dozen servers > and several dozen databases on each, and they occasionally need to run huge > reports which slow down other services. This is of course "legacy code". > Af

[PERFORM] Sort-of replication for reporting purposes

2017-01-06 Thread Ivan Voras
Hello, I'm investigating options for an environment which has about a dozen servers and several dozen databases on each, and they occasionally need to run huge reports which slow down other services. This is of course "legacy code". After some discussion, the idea is to offload these reports to se

Re: [PERFORM] Slow query after 9.3 to 9.6 migration

2017-01-06 Thread Filipe Oliveira
Thank you for the reply. I had been trying to find that option for awhile now. On Fri, Jan 6, 2017 at 12:51 PM, Michael Paquier wrote: > On Fri, Jan 6, 2017 at 6:14 AM, Filipe Oliveira > wrote: > > Can you remove me from your mailing list? > > There is an unsubscribe action here: > https://www.

Re: [PERFORM] Slow query after 9.3 to 9.6 migration

2017-01-06 Thread Michael Paquier
On Fri, Jan 6, 2017 at 6:14 AM, Filipe Oliveira wrote: > Can you remove me from your mailing list? There is an unsubscribe action here: https://www.postgresql.org/community/lists/subscribe/ -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make change