Re: Postgresqlism & Vacuum?

> Ed Loehr wrote:
>
> > ... it is a well-known "postgresqlism"
> > that you should consider running vacuum analyze at least nightly, possibly
> > more frequently.  [I run it hourly.]
>
> I think there must be something wrong with the optimiser that it's
> "postgresqlism" that you must vacuum analyze frequently.  Just as an example,
> for Clipper (dBase compiler), it's Clipperism that you must re-index if you
> cannot locate some records just because the indexing module screws up.

Vacuum collects stats on table size on every run.  Vacuum analyze every
night is a waste unless the tables are really changing dramatically
every day.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  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, Pennsylvania 19026