On 7 October 2010 12:38, AI Rumman <rummandba@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
