On 02/03/14 05:08, bricklen wrote:
On Fri, Feb 28, 2014 at 1:54 PM, Matthew Chambers
mailto:mchamb...@wetafx.co.nz>> wrote:
Initially, I had my application servers using the slave for short,
read only queries, but this turned out to be highly unstable. The
slave would start refusi
On Fri, Feb 28, 2014 at 1:54 PM, Matthew Chambers wrote:
>
> Initially, I had my application servers using the slave for short, read
> only queries, but this turned out to be highly unstable. The slave would
> start refusing connections, and the logs would fill with:
>
> ERROR: canceling statemen
Hi,
I have a postgres server that is fairly high traffic. (about 5MB/second
in writes to SSD backed Netapp NFS storage). The outbound network
traffic for this machine averages 61MB/second, but gets over
250MB/second during peal times. (includes data to slave + user requests)
Initially, I h
