[GENERAL] Wiki page on vacuum full

[Craig Ringer]

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

--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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:
>
> 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.

[Jérôme Etévé]

Great pages!

Thanks for sharing this.

J.

2009/11/26 Craig Ringer <cr...@postnewspapers.com.au>:

--
Jerome Eteve.
http://www.eteve.net
jer...@eteve.net