Maximum reasonable bgwriter_delay

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Maximum reasonable bgwriter_delay
Date: 2007-06-19 14:53:19
Message-ID: 4677EDDF.7070000@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The maximum for bgwriter_delay is currently 10 seconds. That's a long
time, and in fact if you set it to a value greater than 1 s, the sleep
is split into 1 s intervals with a call to AbsorbFsyncRequests in
between them.

Is there a use case for a setting > 1 s? We could simplify that logic a
little bit if we just set the maximum at 1 s.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2007-06-19 18:23:37 Re: to partition or not to partition that is the question
Previous Message Tom Lane 2007-06-19 14:15:50 Re: What does Page Layout version mean? (Was: Re: Reducing NUMERIC size for 8.3)