Re: [GENERAL] verifying database integrity?

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: [GENERAL] verifying database integrity?
Дата
Msg-id 375D5F21.14A1BB7@krs.ru
обсуждение исходный текст
Ответ на verifying database integrity?  (Valerie Mates <popcorn@tir.com>)
Ответы Re: [GENERAL] verifying database integrity?
Список pgsql-general
Valerie Mates wrote:
>
> Hi -- Some clod turned off the power to my customer's computer -- a Linux
> box with a Postgres server on it -- while it was running.  Ever since then,
> certain PostgreSQL queries have been very slow.  We wonder how to tell if
> the database was damaged.  Is there a program we can run to check the
> integrity of the database?  (And is this the right list for me to ask this
> question on?)

Rebuild your indices.
Run vacuum verbose.

Vadim

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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: New Support Level: Per Incident
Следующее
От: The Hermit Hacker
Дата:
Сообщение: PostgreSQL, Inc: The Mission Statement ...