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

On 01/06/2017 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". After some discu

Re: [PERFORM] How can I find the source of postgresql per-connection memory leaks?

On 01/12/2017 09:08 AM, Eric Jensen wrote: I'm using postgresql 9.5.4 on amazon RDS with ~1300 persistent connections from rails 4.2 with "prepared_statements: false". Over the enter image description here PostgreSQL on RDS is a closed product. My recommendation would be to contact Amazon supp

[PERFORM] How can I find the source of postgresql per-connection memory leaks?

I'm using postgresql 9.5.4 on amazon RDS with ~1300 persistent connections from rails 4.2 with "prepared_statements: false". Over the course of hours and days, the "Freeable Memory" RDS stat continues to go down indefinitely but jumps back up to a relatively small working set every time we reconnec