| From: | Leonardo Francalanci <m_lists(at)yahoo(dot)it> |
|---|---|
| To: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>, AI Rumman <rummandba(at)gmail(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: VACUUM FULL for performance |
| Date: | 2010-10-07 13:29:45 |
| Message-ID: | 888825.2758.qm@web29013.mail.ird.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> > MayVACUUM FULL on a table improve perfromance of the system?
>
> No, it will make things worse.
???
Why?
"The FULL option is not recommended for routine use, but might be useful
in special cases. An example is when you have deleted or updated most
of the rows in a table and would like the table to physically shrink to
occupy less disk space and allow faster table scans"
This is for 9.0.
For 8.4 I think the indexes on the table could grow; but seq scan on the
table will be faster than with a plain vacuum...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Szymon Guz | 2010-10-07 13:33:38 | Re: VACUUM FULL for performance |
| Previous Message | Greg Smith | 2010-10-07 12:54:55 | Re: Post Install / Secure PostgreSQL |