Re: [GENERAL] Vacuum clarifications/issues

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема Re: [GENERAL] Vacuum clarifications/issues
Дата
Msg-id Pine.BSF.4.21.9912171045260.4452-100000@thelab.hub.org
обсуждение исходный текст
Ответ на Vacuum clarifications/issues  ("Differentiated Software Solutions Pvt. Ltd." <diffs@vsnl.com>)
Список pgsql-general
On Fri, 17 Dec 1999, Differentiated Software Solutions Pvt. Ltd. wrote:

> Hi,
>
> I'm vacuming a table containing 300,000 rows with a single index.
> Currently it is taking 1.5 hours to complete. It was faster earlier.
> I have dropped and recreated and reloaded this table. THis does not seem to
> help.
>
> Further... vacuum returns several messages.... like crashed... unused...
> moved etc.,
> Some of them have numbers.
> Can anybody tell me what I should do with these and how to interpret them
> etc.,

Post them? :)

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


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

Предыдущее
От: "Differentiated Software Solutions Pvt. Ltd."
Дата:
Сообщение: Vacuum clarifications/issues
Следующее
От: Charles Alexander Randle
Дата:
Сообщение: Re: SCO Openserver & pg_hba.conf