| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Jack Coates <jack(at)lyris(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: tuning questions |
| Date: | 2003-12-04 18:12:30 |
| Message-ID: | Pine.LNX.4.33.0312041111470.17542-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Thu, 4 Dec 2003, Josh Berkus wrote:
> Scott,
>
> > Just to add to what the others have said here, you probably want to run
> > the pg_autovacuum daemon in the background. It comes with 7.4 but will
> > work fine with 7.3.
>
> I don't recommend using pg_autovacuum with a data transformation task. pg_av
> is designed for "regular use" not huge batch tasks.
What bad thing is likely to happen if it's used here? Fire too often or
use too much I/O bandwidth? Would that be fixed by the patch being tested
to introduce a delay every x pages of vacuuming?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2003-12-04 18:35:32 | Re: autovacuum daemon stops doing work after about an hour |
| Previous Message | Andrew Sullivan | 2003-12-04 18:11:52 | Re: tuning questions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2003-12-04 18:35:32 | Re: autovacuum daemon stops doing work after about an hour |
| Previous Message | Andrew Sullivan | 2003-12-04 18:11:52 | Re: tuning questions |