Re: Large transaction problem

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Large transaction problem
Дата
Msg-id 20041112143349.GA32479@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: Large transaction problem  ("Paul B. Anderson" <paul@pnlassociates.com>)
Ответы Re: Large transaction problem  ("Paul B. Anderson" <paul@pnlassociates.com>)
Consult is very slow  (Vida Luz <vlal@ideay.net.ni>)
Список pgsql-admin
Дерево обсуждения 
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

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner

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

Предыдущее
От: Francisco Jose Bernabe Pellicer
Дата:
Сообщение: Query failed: ERROR: Unable to identify an operator '=' for types 'character varying' and 'character'
Следующее
От: "Paul B. Anderson"
Дата:
Сообщение: Re: Large transaction problem