Wiki page on vacuum full

Started by Craig Ringerover 16 years ago3 messagesgeneral
Jump to latest
#1Craig Ringer
craig@2ndquadrant.com

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

#2Craig Ringer
craig@2ndquadrant.com
In reply to: Craig Ringer (#1)
Re: Wiki page on vacuum full

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:

http://wiki.postgresql.org/index.php?title=VACUUM_FULL

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

#3Jérôme Etévé
jerome.eteve@gmail.com
In reply to: Craig Ringer (#2)
Re: Wiki page on vacuum full

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:

http://wiki.postgresql.org/index.php?title=VACUUM_FULL

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