| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: About vacuuming |
| Date: | 2002-02-28 04:29:21 |
| Message-ID: | 1014870562.3476.6.camel@jiro |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2002-02-27 at 22:32, Frank Bax wrote:
> Unless something changed in
> recent versions, you can only run analyse as part of vacuum.
This is no longer the case with PostgreSQL 7.2 -- there is a separate
ANALYZE command. Check the 7.2 docs for more info on the changes to
VACUUM in this release. Basically, vacuuming is now substantially less
onerous: it is faster and doesn't require an exclusive lock on the
table. ANALYZE now uses statistical sampling for large tables (instead
of scanning every row), so it should be significantly faster as well.
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Loh | 2002-02-28 07:02:15 | Benefit of postgresql and benchmark |
| Previous Message | Bruce Momjian | 2002-02-28 04:11:49 | Re: sort mem size |