Re: How to shrink database in postgresql

Поиск
Список
Период
Сортировка
От Mario Marín
Тема Re: How to shrink database in postgresql
Дата
Msg-id CACX0pozH6anBqWJryG_Z_T0AGHouafHxxKqoMtiWFS3uBa-wUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to shrink database in postgresql  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-sql
2012/2/29 Pavel Stehule <pavel.stehule@gmail.com>:
> Hello
>
> the most similar tool in pg is "VACUUM FULL" statemet;

Hello,

From: http://wiki.postgresql.org/wiki/VACUUM_FULL "Many people, either
based on misguided advice on the 'net or on the assumption that it
must be "better", periodically run VACUUM FULL on their tables. This
is generally a really bad idea and can make your database slower not
faster",  it is better to use  autovacuum. Please read the wiki,
you'll find all the information you need.

Regards,

Mario Marín


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

Предыдущее
От: Philip Couling
Дата:
Сообщение: Re: How To Create Temporary Table inside a function
Следующее
От: Emi Lu
Дата:
Сообщение: Re: Change Ownership Recursively