Re: Postgres locking up?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Postgres locking up?
Дата
Msg-id 20060929193006.GF23697@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Postgres locking up?  (Brian Hurt <bhurt@janestcapital.com>)
Список pgsql-performance
On Fri, Sep 29, 2006 at 03:24:14PM -0400, Brian Hurt wrote:
> I'm experiencing a problem with our postgres database.  Queries that
> normally take seconds suddenly start taking hours, if they complete at
> all.

The first thing I'd do is EXPLAIN and EXPLAIN ANALYSE on the queries
in question.

The next thing I'd look for is OS-level performance problems.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what
you told them to.  That actually seems sort of quaint now.
        --J.D. Baldwin

В списке pgsql-performance по дате отправления:

Предыдущее
От: Brian Hurt
Дата:
Сообщение: Postgres locking up?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [NOVICE] Postgres locking up?