Thread: Does "vacuum analyze" contain "vacuum"?
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 enough? I am not sure if "vacuum analyze" contains a "vacuum". Regards Holger -- PGP/GPG Key-ID: http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
On Sun, 7 Sep 2003 14:04:51 +0200 (CEST), Holger Marzen <holger@marzen.de> wrote: >[...] (in version 7.1.x, 7.2.x) [...] is a > >vacuum analyze > >enough? As far as I remember, yes. BTW, what keeps you from upgrading to 7.3.4? Servus Manfred
On Sun, 7 Sep 2003, Manfred Koizar wrote: > On Sun, 7 Sep 2003 14:04:51 +0200 (CEST), Holger Marzen > <holger@marzen.de> wrote: > >[...] (in version 7.1.x, 7.2.x) [...] is a > > > >vacuum analyze > > > >enough? > > As far as I remember, yes. > BTW, what keeps you from upgrading to 7.3.4? Never change a running system. -- PGP/GPG Key-ID: http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
Holger Marzen writes: > I am not sure if "vacuum analyze" contains a "vacuum". "vacuum analyze" = "vacuum" + "analyze" -- Peter Eisentraut peter_e@gmx.net
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.
On 8 Sep 2003, Matthew T. O'Connor wrote: > 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: 7.2 for sure had analyze. I'm still using it in production (although it is getting a bit long in the tooth nowadays) Looking at the docs for 7.1, it didn't.
On Sun, Sep 07, 2003 at 09:24:36PM +0200, Holger Marzen wrote:
>
> Never change a running system.
Well, unless the running system has known bugs. Which 7.1 and 7.2
both assuredly do.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110