Postgres Pro
Downloads
Home   >   mailing lists

Re: How to shrink database in postgresql - Mailing list pgsql-sql

From Mario Marín
Subject Re: How to shrink database in postgresql
Date
Msg-id CACX0pozH6anBqWJryG_Z_T0AGHouafHxxKqoMtiWFS3uBa-wUQ@mail.gmail.com
Whole thread Raw
In response to Re: How to shrink database in postgresql  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: Philip Couling
Date:
Subject: Re: How To Create Temporary Table inside a function
Next
From: Emi Lu
Date:
Subject: Re: Change Ownership Recursively