Received: from mail1.expertrade.com (r87-43-dsl.sea.lightrealm.net
	[216.122.43.87])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f5DJ4IE64843
	for <pgsql-general@postgresql.org>;
	Wed, 13 Jun 2001 15:04:18 -0400 (EDT)
	(envelope-from d.wall@computer.org)
Received: from reggae (reggae.expertrade.com [216.122.43.90])
	by mail1.expertrade.com (8.9.3/8.9.3) with SMTP id MAA11529
	for <pgsql-general@postgresql.org>; Wed, 13 Jun 2001 12:04:10 -0700
Message-ID: <00c401c0f43b$a5423000$5a2b7ad8@expertrade.com>
Reply-To: "David Wall" <d.wall@computer.org>
From: "David Wall" <d.wall@computer.org>
To: <pgsql-general@postgresql.org>
Subject: Vacuum analyze in 7.1.1
Date: Wed, 13 Jun 2001 12:04:17 -0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00C1_01C0F400.F8D28F20"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
X-Archive-Number: 200106/487
X-Sequence-Number: 10974

This is a multi-part message in MIME format.

------=_NextPart_000_00C1_01C0F400.F8D28F20
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Does a 'vacuum analyze' do the same functions as a plain 'vacuum' PLUS the =
stats updates?  Just wondering if I need to run both commands from time to =
time, or if I can just do 'vacuum analyze'?  I'm running 7.1.1 now.

Thanks,
David

------=_NextPart_000_00C1_01C0F400.F8D28F20
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4613.1700" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Does a 'vacuum analyze' do the same functi=
ons as a=20
plain 'vacuum' PLUS the stats updates?&nbsp; Just wondering if I need to ru=
n=20
both commands from time to time, or if I can just do 'vacuum analyze'?&nbsp=
; I'm=20
running 7.1.1 now.<BR><BR>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>David</FONT></DIV></BODY></HTML>

------=_NextPart_000_00C1_01C0F400.F8D28F20--