n and post back, but if you don't hear from me again you can assume the
problem is solved.
Thank you all again for the help.
-Dave
On Fri, Sep 13, 2013 at 11:05 AM, David Whittaker wrote:
>
>
>
> On Fri, Sep 13, 2013 at 10:52 AM, Merlin Moncure wrote:
>
>> On Thu, Sep
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 t
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
Hi Jeff
On Tue, Sep 10, 2013 at 1:44 PM, Jeff Janes wrote:
> 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 ab
Hi Ken,
On Tue, Sep 10, 2013 at 11:33 AM, k...@rice.edu wrote:
> 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 som
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 about a
>> year now, and I was hoping someone mi
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 application nodes it services. These periods tend to l
oint I don't think THP
is the root cause though, so I'm curious to see if anyone else gets
positive results from disabling it. We definitely haven't seen any
performance hit from turning it off.
> On Wed, Feb 6, 2013 at 10:42 AM, David Whittaker wrote:
>
>> Josh/Johnny
Josh/Johnny,
We've been seeing a similar problem as well, and had also figured THP was
involved. We found this in syslog:
https://gist.github.com/davewhittaker/4723285, which led us to disable THP
2 days ago. At first the results seemed good. In particular, our issues
always seemed interrupt re
