From: Vivek Khera <khera@kcilink.com>
To: pgsql-performance@postgresql.org
Subject: Re: autovacuum daemon stops doing work after about an hour
Date: Mon, 08 Dec 2003 13:41:12 -0500
Message-ID: <x7fzfvjgon.fsf@yertle.int.kciLink.com> (raw)
References: <16332.63508.196365.801418@yertle.int.kciLink.com>
<1070516326.1455.11.camel@zedora.zeut.net>
<16335.25079.106697.7521@yertle.int.kciLink.com>
<3FCF7E74.9060604@bigfoot.com>
<m3y8top0pe.fsf@wolfe.cbbrowne.com>
<3FD40BC1.7050906@zeut.net>
>>>>> "MTO" == Matthew T O'Connor <matthew@zeut.net> writes:
MTO> Yeah, FreeBSD testing would have been nice, but I don't have access to
MTO> any FreeBSD boxes so.....
FWIW, with the fflush() added after that sleep, and the fix to the
long long computation of sleep time to keep it from overflowing,
pg_autovacuum has been working flawlessly on my FreeBSD 4.9 + PG 7.4.0
production server. I'm just still playing with tuning pg_autovacuum
to keep it from vacuuming my busy tables *too* often.
Just a question: will my test program show negative sleep 'diff' on
your linux box? I can't imagine that it would give different results
than on freebsd.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: khera@kcilink.com
Subject: Re: autovacuum daemon stops doing work after about an hour
In-Reply-To: <x7fzfvjgon.fsf@yertle.int.kciLink.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox