From: Bruce Momjian <maillist@candle.pha.pa.us>
Message-Id: <199903101911.OAA19707@candle.pha.pa.us>
Subject: Re: [SQL] Performance
In-Reply-To: <19990310124620.A18684@Denninger.Net> from Karl Denninger at "Mar
	10, 1999 12:46:20 pm"
To: karl@Denninger.Net (Karl Denninger)
Date: Wed, 10 Mar 1999 14:11:39 -0500 (EST)
Cc: raistlin@tacorp.net, tgl@sss.pgh.pa.us, pgsql-sql@hub.org
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

> That's a waste - a vacuum on a table with no deletes having been executed
> and no indices will go through everything and do absolutely nothing :-)

Ah, but VACUUM ANALYZE does statistics, which is needed.  I should break
out ANALYZE as a separate command.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026