Re: Large transaction problem

Поиск
Список
Период
Сортировка
От Paul B. Anderson
Тема Re: Large transaction problem
Дата
Msg-id 4194D713.3000402@pnlassociates.com
обсуждение исходный текст
Ответ на Re: Large transaction problem  (Andrew Sullivan <ajs@crankycanuck.ca>)
Ответы Re: Large transaction problem  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-admin
When the vacuum full timed out, could the exclusive lock have been left set, leaving the database in an unusable state?

BTW, thanks.  I removed the --full option. 

Paul


Andrew Sullivan wrote:
On Thu, Nov 11, 2004 at 05:14:50PM -0500, Paul B. Anderson wrote: 
 /usr/bin/vacuumdb --all --full --analyze   
                            ^^^^^

You do realise that takes an exclusive lock, right?  Why are you
doing VACUUM FULL?  If your FSM is set right, you really shouldn't
need it for most cases.

A
 

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Large transaction problem
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Large transaction problem