Re: Postgres Databases growing without much reason

Поиск
Список
Период
Сортировка
От Jeff Eckermann
Тема Re: Postgres Databases growing without much reason
Дата
Msg-id 20030214150607.51422.qmail@web20801.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Postgres Databases growing without much reason  (Andreas Rust <rust@webnova.de>)
Список pgsql-general
--- Andreas Rust <rust@webnova.de> wrote:

> After an advice, I just did "vacuum full" instead of
> analyze and that
> brought the DB
> down to some 350 MB again ...

That will shrink the on-disk size of the tables, but
not the indexes.  There is work going on to fix this
for the next version of PostgreSQL, but in the
meantime you will need to look at a workaround if
index growth becomes a problem for you.  Search the
archives for references to "index bloat" and "reindex"
and you should find plenty of stuff.

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Diff between Primary key and non primary key select
Следующее
От: Jeff Eckermann
Дата:
Сообщение: Re: uppercase = lowercase