Re: Slow queries (high duration) and their log entries appearing out-of-order

From: Jonathan Barber <jonathan(dot)barber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow queries (high duration) and their log entries appearing out-of-order
Date: 2011-07-12 11:59:22
Message-ID: CAPEiEj5PQEjVr5J=7ZAhEcGLMWFsjbOFoE0Ls_tvjxys_HyszA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11 July 2011 17:19, Jonathan Barber <jonathan(dot)barber(at)gmail(dot)com> wrote:
> I'm trying to debug a jboss/hibernate application that uses PostgreSQL
> as a backend, for which PostgreSQL is reporting a lot of queries as
> taking around 4398046 ms (~73 minutes) plus or minus 10 ms to
> complete. I have two questions about this.

Just in case anyone else hits this, I tracked it down to the following
linux kernel issue:
http://lkml.org/lkml/2008/3/30/123

And for Red Hat:
https://bugzilla.redhat.com/show_bug.cgi?id=452185

Cheers
--
Jonathan Barber <jonathan(dot)barber(at)gmail(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Grace Batumbya 2011-07-12 13:03:17 PostgreSQL JDBC: bytea column getMetaData().getColumns().getIn("COLUMN_SIZE") ~ 2GB
Previous Message Tim Uckun 2011-07-12 10:12:52 Re: Unexpected results with joins on dates