Re: VACUUM ANALYZE--how often?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jboes(at)nexcerpt(dot)com (Jeff Boes)
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: VACUUM ANALYZE--how often?
Date: 2002-01-16 05:42:52
Message-ID: 7559.1011159772@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

jboes(at)nexcerpt(dot)com (Jeff Boes) writes:
> Our database has about 70 tables. Only a half-dozen or so have more
> than 100K rows, and all of these change (99% inserts, 10K-50K rows)
> during an average day.

> VACUUM ANALYZE takes over an hour, and it's edging up by a couple
> minutes per day.

Care to try 7.2?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message juerg.rietmann 2002-01-16 07:50:24 postgreSQL Version 7.2 for SuSE Linux
Previous Message David Stanaway 2002-01-15 22:29:20 Re: Monitoring database