On 7 October 2010 12:38, AI Rumman <rummandba@gmail.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