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

Поиск
Список
Период
Сортировка
От Jonathan Barber
Тема Re: Slow queries (high duration) and their log entries appearing out-of-order
Дата
Msg-id CAPEiEj5PQEjVr5J=7ZAhEcGLMWFsjbOFoE0Ls_tvjxys_HyszA@mail.gmail.com
обсуждение исходный текст
Ответ на Slow queries (high duration) and their log entries appearing out-of-order  (Jonathan Barber <jonathan.barber@gmail.com>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Adrian Parker
Дата:
Сообщение: Alter Columns with Triggers
Следующее
От: Grace Batumbya
Дата:
Сообщение: PostgreSQL JDBC: bytea column getMetaData().getColumns().getIn("COLUMN_SIZE") ~ 2GB