Re: What to do about a vacuum...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What to do about a vacuum...
Дата
Msg-id 418.1028900838@sss.pgh.pa.us
обсуждение исходный текст
Ответ на What to do about a vacuum...  ("Robert M. Meyer" <rmeyer@installs.com>)
Ответы Re: What to do about a vacuum...  ("Robert M. Meyer" <rmeyer@installs.com>)
Список pgsql-admin
"Robert M. Meyer" <rmeyer@installs.com> writes:
> IN my infinite wisdom, in an effort to resolve my performance problems,
> I started a full vacuum of my database last night around 4:00AM.  It's
> still running at 9;20AM and it has all of the tables locked.

Huh?  Vacuum should only lock one table at a time.

> Is it safe to cancel the query from inside pgmonitor?

Yes, a SIGINT should be safe enough.  You'll lose the benefit of whatever
vacuuming work has been done so far on the current table.

            regards, tom lane

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

Предыдущее
От: "Robert M. Meyer"
Дата:
Сообщение: What to do about a vacuum...
Следующее
От: "Robert M. Meyer"
Дата:
Сообщение: Re: What to do about a vacuum...