[GENERAL] scaling postgres

2015-08-02 Thread Chris Withers
Hi All, I'm curious if there are recommendations for scaling postgres to what, for me, seems like "a lot" of data... The app in question currently writes around 1.5 billion rows into a table before rolling them up into tables that have a few million roll up rows each. That 1.5 billion row ta

Re: [GENERAL] Lots of stuck queries after upgrade to 9.4

2015-08-02 Thread Heikki Linnakangas
On 07/30/2015 04:23 PM, Spiros Ioannou wrote: I'm very sorry but we don't have a synthetic load generator for our testing setup, only production and that is on SLA. I would be happy to test the next release though. Ok, no worries. I've pushed this changes, it will appear in the next release. T