Re: AccessShareLock and Resource Contention - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: AccessShareLock and Resource Contention
Date
Msg-id 20131126191820.GJ6597@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: AccessShareLock and Resource Contention  (maillists0@gmail.com)
List pgsql-general
> On Tue, Nov 26, 2013 at 12:41 PM, <maillists0@gmail.com> wrote:
>
> > I have a 9.2 server that occasionally becomes CPU bound. Disk wait is
> > nominal and there's no memory pressure. The workload is almost all reads
> > and the cache hit rate is high.

Maybe you'd benefit from something like the patch proposed here:

http://www.postgresql.org/message-id/20131115194725.GG5489@awork2.anarazel.de
perhaps you can help test the patchset.


--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Any advantage of using SSL with a certificate of authority?
Next
From: Vick Khera
Date:
Subject: Re: Any advantage of using SSL with a certificate of authority?