Re: [PERFORM] Intermittent hangs with 9.2

2013-09-20 Thread David Whittaker
We haven't seen any issues since we decreased shared_buffers. We also tuned some of the longer running / more frequently executed queries, so that may have had an effect as well, but my money would be on the shared_buffers change. If the issue re-appears I'll try to get a perf again and post back

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-13 Thread David Whittaker
On Fri, Sep 13, 2013 at 10:52 AM, Merlin Moncure wrote: > On Thu, Sep 12, 2013 at 3:06 PM, David Whittaker wrote: > > Hi All, > > > > We lowered shared_buffers to 8G and increased effective_cache_size > > accordingly. So far, we haven't seen any issues since the adjustment. > The > > issues ha

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-13 Thread Merlin Moncure
On Thu, Sep 12, 2013 at 3:06 PM, David Whittaker wrote: > Hi All, > > We lowered shared_buffers to 8G and increased effective_cache_size > accordingly. So far, we haven't seen any issues since the adjustment. The > issues have come and gone in the past, so I'm not convinced it won't crop up > ag

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-12 Thread David Whittaker
Hi All, We lowered shared_buffers to 8G and increased effective_cache_size accordingly. So far, we haven't seen any issues since the adjustment. The issues have come and gone in the past, so I'm not convinced it won't crop up again, but I think the best course is to wait a week or so and see how

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-11 Thread Merlin Moncure
On Wed, Sep 11, 2013 at 12:17 PM, Andres Freund wrote: > On 2013-09-11 07:43:35 -0500, Merlin Moncure wrote: >> > I've been seeing a strange issue with our Postgres install for about a year >> > now, and I was hoping someone might be able to help point me at the cause. >> > At what seem like fairl

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-11 Thread Andres Freund
On 2013-09-11 07:43:35 -0500, Merlin Moncure wrote: > > I've been seeing a strange issue with our Postgres install for about a year > > now, and I was hoping someone might be able to help point me at the cause. > > At what seem like fairly random intervals Postgres will become unresponsive > > to t

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-11 Thread Merlin Moncure
On Tue, Sep 10, 2013 at 10:04 AM, David Whittaker wrote: > Hi All, > > I've been seeing a strange issue with our Postgres install for about a year > now, and I was hoping someone might be able to help point me at the cause. > At what seem like fairly random intervals Postgres will become unrespons

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-11 Thread Julien Cigar
On Tue, Sep 10, 2013 at 02:04:57PM -0400, David Whittaker wrote: > Hi Andrew, > > > On Tue, Sep 10, 2013 at 11:26 AM, Andrew Dunstan wrote: > > > > > On 09/10/2013 11:04 AM, David Whittaker wrote: > > > >> > >> Hi All, > >> > >> I've been seeing a strange issue with our Postgres install for abou

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-11 Thread Torsten Förtsch
On 10/09/13 20:04, David Whittaker wrote: > On Tue, Sep 10, 2013 at 11:26 AM, Andrew Dunstan > wrote: > > > On 09/10/2013 11:04 AM, David Whittaker wrote: > > > Hi All, > > I've been seeing a strange issue with our Postgres install for >

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-10 Thread Jeff Janes
On Tue, Sep 10, 2013 at 8:04 AM, David Whittaker wrote: > Hi All, > > I've been seeing a strange issue with our Postgres install for about a > year now, and I was hoping someone might be able to help point me at the > cause. At what seem like fairly random intervals Postgres will become > unrespo

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-10 Thread k...@rice.edu
On Tue, Sep 10, 2013 at 11:04:21AM -0400, David Whittaker wrote: > Hi All, > > I've been seeing a strange issue with our Postgres install for about a year > now, and I was hoping someone might be able to help point me at the cause. > At what seem like fairly random intervals Postgres will become u

Re: [PERFORM] Intermittent hangs with 9.2

2013-09-10 Thread Andrew Dunstan
On 09/10/2013 11:04 AM, David Whittaker wrote: Hi All, I've been seeing a strange issue with our Postgres install for about a year now, and I was hoping someone might be able to help point me at the cause. At what seem like fairly random intervals Postgres will become unresponsive to the 3