Re: Database growth problem

Поиск
Список
Период
Сортировка
От Mendola Gaetano
Тема Re: Database growth problem
Дата
Msg-id 004401c34cff$50a46b70$10d4a8c0@mm.eutelsat.org
обсуждение исходный текст
Ответ на Database growth problem  (mlaks <mlaks@bellatlantic.net>)
Список pgsql-admin
"mlaks" <mlaks@bellatlantic.net> wrote:
> But I run vaccuum analyze at the same frequency as on the PC's? How is it
that
> deleting and saving and vacuum analyze doesnt keep it at a normal svelte
<1Gb
> in size?
>
> What should  I do to shrink it back down to its normal svelte shape?

Did you try to vacuum full and reindex the big tables ?

Regards
Gaetano
Mendola



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

Предыдущее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: Adding PL/Perl
Следующее
От: Dani Oderbolz
Дата:
Сообщение: Re: pg_dump: dumpBlobs(): error reading large object: ERROR: