| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | 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 11:44:56 |
| Message-ID: | AANLkTimRApRUtws1KW3e1-NhhEuDjfuAuBzOTRBy0X2t@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 7 October 2010 12:38, AI Rumman <rummandba(at)gmail(dot)com> wrote:
> MayVACUUM FULL on a table improve perfromance of the system?
>
Please treat VACUUM FULL as a last resort. Read this:
http://wiki.postgresql.org/wiki/VACUUM_FULL
A VACUUM ANALYZE will mark dead tuples as free and update the stats.
Also check your query plans to see where the real bottlenecks are.
Is your system properly configured too? Check out
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GÜNDÜZ | 2010-10-07 12:01:42 | Re: VACUUM FULL for performance |
| Previous Message | AI Rumman | 2010-10-07 11:38:24 | VACUUM FULL for performance |