On Sun, 2003-09-07 at 08:04, Holger Marzen wrote:
> Hi all,
>
> the docs are not clear for me. If I want (in version 7.1.x, 7.2.x) to
> help the analyzer AND free unused space do I have to do a
>
> vacuum
> vacuum analyze
>
> or is a
>
> vacuum analyze
vacuum analyze = vacuum + analyze
FYI, I don't remember it if was added in 7.2, or 7.3, but you can now
do:
vacuum = just vacuum
vacuum analyze = vacuum + analyze
analyze = just analyze
analyze is all you need if you want to update planner statistics without
trying to reclaim any space.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
