> (1) The statistics-gathering process should be available as a standalone
> command, ANALYZE [ tablename ], not only as part of VACUUM. (This was
> already discussed and agreed to for 7.1, but it never got done.) Note
> that a pure ANALYZE command needs only a read lock on the target table,
> not an exclusive lock as VACUUM needs, so it's much more friendly to
> concurrent transactions.
7.1 already does the ANALYZE part of VACUUM ANALYZE with lighter
locking. I just never split out the command to be separate, partly
because of fear of user confusion, and I ran out of time.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026