From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Thomas <englim(at)pc(dot)jaring(dot)my> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresqlism & Vacuum? |
Date: | 2000-04-14 11:18:22 |
Message-ID: | 200004141118.HAA24339@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Colin Smith | 2000-04-14 11:51:07 | Re: [Fwd: [HACKERS] Porting reports (cont'd)] |
Previous Message | Andy Lewis | 2000-04-14 11:13:05 | Re: Postgresqlism & Vacuum? |