[PERFORM] Intermittent hangs with 9.2

2013-09-10 Thread David Whittaker
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 able to help point me at the >> cause. At

[PERFORM] Intermittent hangs with 9.2

2013-09-10 Thread David Whittaker
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 someone might be able to help point me at

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

[PERFORM] Intermittent hangs with 9.2

2013-09-10 Thread David Whittaker
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 might be able to help point me at the >> cause.

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

[PERFORM] Intermittent hangs with 9.2

2013-09-10 Thread David Whittaker
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

Re: [PERFORM] Performance bug in prepared statement binding in 9.2?

2013-09-10 Thread Andrew Dunstan
On 09/10/2013 09:23 AM, Andres Freund wrote: On 2013-09-10 15:21:33 +0200, Andres Freund wrote: If I interpret things correctly you're using serializable? I guess there is no chance to use repeatable read instead? Err, that wouldn't help much. Read committed. That lets PGXACT->xmin advance the

Re: [PERFORM] Performance bug in prepared statement binding in 9.2?

2013-09-10 Thread Andres Freund
On 2013-09-10 15:21:33 +0200, Andres Freund wrote: > If I interpret things correctly you're using serializable? I guess there > is no chance to use repeatable read instead? Err, that wouldn't help much. Read committed. That lets PGXACT->xmin advance these days and thus might help to reduce the imp

Re: [PERFORM] Performance bug in prepared statement binding in 9.2?

2013-09-10 Thread Andres Freund
On 2013-09-10 08:45:33 -0400, Andrew Dunstan wrote: > > On 09/10/2013 08:20 AM, Andres Freund wrote: > > >A backtrace for this would be useful. Alternatively you could recompile > >postgres using -fno-omit-frame-pointer in CFLAGS and use perf record -g. > > It's using a custom build, so this sho

Re: [PERFORM] Performance bug in prepared statement binding in 9.2?

2013-09-10 Thread Andrew Dunstan
On 09/10/2013 08:20 AM, Andres Freund wrote: A backtrace for this would be useful. Alternatively you could recompile postgres using -fno-omit-frame-pointer in CFLAGS and use perf record -g. It's using a custom build, so this should be doable. Any chance you have older prepared xacts, older

Re: [PERFORM] Performance bug in prepared statement binding in 9.2?

2013-09-10 Thread Andres Freund
Hi, On 2013-09-09 20:38:09 -0400, Andrew Dunstan wrote: > > On 08/01/2013 03:20 PM, Jeff Janes wrote: > >On Thu, Aug 1, 2013 at 10:58 AM, Josh Berkus wrote: > >>Amit, All: > >> > >>So we just retested this on 9.3b2. The performance is the same as 9.1 > >>and 9.2; that is, progressively worse as

Re: [PERFORM] Performance bug in prepared statement binding in 9.2?

2013-09-10 Thread Andres Freund
On 2013-09-09 20:38:09 -0400, Andrew Dunstan wrote: > > On 08/01/2013 03:20 PM, Jeff Janes wrote: > >On Thu, Aug 1, 2013 at 10:58 AM, Josh Berkus wrote: > >>Amit, All: > >> > >>So we just retested this on 9.3b2. The performance is the same as 9.1 > >>and 9.2; that is, progressively worse as the

Re: [PERFORM] Performance bug in prepared statement binding in 9.2?

2013-09-10 Thread Bruce Momjian
On Tue, Sep 10, 2013 at 05:43:16AM +, Mel Llaguno wrote: > Bruce, > > First of all, I'd like to thank you for taking some interest in this > issue. We'd love to migrate to the latest PG version, but this issue > is currently preventing us from doing so. > > Regardless of the DB used (base appli