Wiki page on vacuum full
Hi folks
Since it seems to come up a lot, I've added some info on the pitfalls of
VACUUM FULL to the wiki:
http://wiki.postgresql.org/index.php?title=VACUUM_FULL
It intentionally avoids going into details of why index bloat is
created, etc, and just tries to provide accessible advice as to better
solutions to the problems the user may be trying to address with VACUUM
FULL.
Comments?
--
Craig Ringer
Craig Ringer wrote:
Hi folks
Since it seems to come up a lot, I've added some info on the pitfalls of
VACUUM FULL to the wiki:
Similarly, a page on tools to collect and analyze performance data at
the system level - ie outside Pg its self:
http://wiki.postgresql.org/wiki/Performance_Analysis_Tools
since there doesn't seem to be any good central resource for them at the
moment.
I'm sure you folks know of other great tools, and I'd really appreciate
your adding them or fleshing out the rather brief descriptions of what's
there already. I'll be adding more to the descriptions and adding advice
on using the tools and interpreting the results too, but would love help.
--
Craig Ringer
Great pages!
Thanks for sharing this.
J.
2009/11/26 Craig Ringer <craig@postnewspapers.com.au>:
Craig Ringer wrote:
Hi folks
Since it seems to come up a lot, I've added some info on the pitfalls of
VACUUM FULL to the wiki:Similarly, a page on tools to collect and analyze performance data at
the system level - ie outside Pg its self:http://wiki.postgresql.org/wiki/Performance_Analysis_Tools
since there doesn't seem to be any good central resource for them at the
moment.I'm sure you folks know of other great tools, and I'd really appreciate
your adding them or fleshing out the rather brief descriptions of what's
there already. I'll be adding more to the descriptions and adding advice
on using the tools and interpreting the results too, but would love help.--
Craig Ringer--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Jerome Eteve.
http://www.eteve.net
jerome@eteve.net