Vacuum clarifications/issues

Поиск
Список
Период
Сортировка
От Differentiated Software Solutions Pvt. Ltd.
Тема Vacuum clarifications/issues
Дата
Msg-id 001801bf4899$7d8c3500$4bb5c5cb@nagma
обсуждение исходный текст
Ответы Re: [GENERAL] Vacuum clarifications/issues
Список pgsql-general
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.,

Thanks,

Murali

Differentiated Software Solutions Pvt. Ltd.,
176, Gr. Floor, 6th Main
2nd Block RT Nagar
Bangalore - 560 032
India
Ph: 91 80 3431470


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

Предыдущее
От: Karl Eichwalder
Дата:
Сообщение: Re: Installation problem on Suse linux 6.3
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [GENERAL] Vacuum clarifications/issues