| From: | Rod Taylor <pg(at)rbt(dot)ca> |
|---|---|
| To: | Edoardo Ceccarelli <eddy(at)axa(dot)it> |
| Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] autovacuum on a -mostly- r/o table |
| Date: | 2006-09-27 16:31:52 |
| Message-ID: | 1159374712.46586.47.camel@home |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
On Wed, 2006-09-27 at 18:08 +0200, Edoardo Ceccarelli wrote:
>
> I have read that autovacuum cannot check to see pg load before
> launching
> vacuum but is there any patch about it? that would sort out the
> problem
> in a good and simple way.
In some cases the solution to high load is to vacuum the tables being
hit the heaviest -- meaning that simply checking machine load isn't
enough to make that decision.
In fact, that high load problem is exactly why autovacuum was created in
the first place.
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edoardo Ceccarelli | 2006-09-27 16:40:22 | Re: autovacuum on a -mostly- r/o table |
| Previous Message | Trefethen, Zachary J | 2006-09-27 16:19:01 | having trouble restoring a database from files |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edoardo Ceccarelli | 2006-09-27 16:40:22 | Re: autovacuum on a -mostly- r/o table |
| Previous Message | Bill Moran | 2006-09-27 16:14:54 | Re: [PERFORM] autovacuum on a -mostly- r/o table |