Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] how to plan for vacuum? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [PERFORM] how to plan for vacuum?
Date
Msg-id 20070125035202.GI26006@alvh.no-ip.org
Whole thread Raw
Responses Re: [PERFORM] how to plan for vacuum?
Re: [PERFORM] how to plan for vacuum?
List pgsql-hackers
Tree view 
Jim C. Nasby wrote:

> I'll generally start with a cost delay of 20ms and adjust based on IO
> utilization.

I've been considering set a default autovacuum cost delay to 10ms; does
this sound reasonable?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-hackers by date:

Previous
From: Jeremy Drake
Date:
Subject: Re: [pgsql-patches] unprivileged contrib and pl install
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [PERFORM] how to plan for vacuum?