| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Wayne Beaver <wayne(at)acedsl(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Manual vacs 5x faster than autovacs? |
| Date: | 2009-11-12 14:49:52 |
| Message-ID: | 24025.1258037392@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Wayne Beaver <wayne(at)acedsl(dot)com> writes:
> Running Pg 8.3RC2, Linux server, w/8GB RAM, OpenSuSE 10.2 OS (yes, I
> know that's old). I have seen *really* long-running autovacs eating up
> system resources. While the below is not an example of *really* long,
> it shows how I killed an autovac which had been running for more than
> 10 minutes, then ran a VAC FULL ANALYZE on same exact table in about
> ~2 min. Any wisdom here? Attributable to autovac_worker settings?
autovacuum_vacuum_cost_delay. Is the slow autovac *really* eating
a noticeable amount of system resources? I would think that a full
speed manual vacuum would be a lot worse.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-11-12 15:14:17 | Re: Manual vacs 5x faster than autovacs? |
| Previous Message | Wayne Beaver | 2009-11-12 14:33:01 | Manual vacs 5x faster than autovacs? |