Postgres Pro
Downloads
Home   >   mailing lists

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

From Jonathan Barber
Subject Re: Slow queries (high duration) and their log entries appearing out-of-order
Date
Msg-id CAPEiEj5PQEjVr5J=7ZAhEcGLMWFsjbOFoE0Ls_tvjxys_HyszA@mail.gmail.com
Whole thread Raw
In response to Slow queries (high duration) and their log entries appearing out-of-order  (Jonathan Barber <jonathan.barber@gmail.com>)
List pgsql-general
Tree view 
On 11 July 2011 17:19, Jonathan Barber <jonathan.barber@gmail.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.barber@gmail.com>

pgsql-general by date:

Previous
From: Adrian Parker
Date:
Subject: Alter Columns with Triggers
Next
From: Grace Batumbya
Date:
Subject: PostgreSQL JDBC: bytea column getMetaData().getColumns().getIn("COLUMN_SIZE") ~ 2GB