From: Matthew T. O'Connor <matthew@zeut.net>
To: Joe Conway <mail@joeconway.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Matthew T. O'Connor <matthew@zeut.net>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Cc: Josh Berkus <josh@agliodbs.com>
Subject: Re: rapid degradation after postmaster restart
Date: Wed, 17 Mar 2004 00:12:20 -0500
Message-ID: <4057DE34.1080001@zeut.net> (raw)
In-Reply-To: <4057D8BD.4080902@joeconway.com>
References: <4052661D.5060505@joeconway.com>
<14884.1079150555@sss.pgh.pa.us>
<4055F343.6070600@joeconway.com>
<405614CA.5030101@zeut.net>
<405689A4.4080406@joeconway.com>
<16735.1079414723@sss.pgh.pa.us>
<4057D8BD.4080902@joeconway.com>
On Tue, 2004-03-16 at 23:49, Joe Conway wrote:
> I have tested Tom's original patch now. The good news -- it works great
> in terms of reducing the load imposed by vacuum -- almost to the level
> of being unnoticeable. The bad news -- in a simulation test which loads
> an hour's worth of data, even with delay set to 1 ms, vacuum of the
> large table exceeds two hours (vs 12-14 minutes with delay = 0). Since
> that hourly load is expected 7 x 24, this obviously isn't going to work.
If memory serves, the problem is that you actually sleep 10ms even when
you set it to 1. One of the thing changed in Jan's later patch was the
ability to specify how many pages to work on before sleeping, rather
than how long to sleep inbetween every 1 page. You might be able to do
a quick hack and have it do 10 pages or so before sleeping.
Matthew
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: matthew@zeut.net, mail@joeconway.com, tgl@sss.pgh.pa.us, josh@agliodbs.com
Subject: Re: rapid degradation after postmaster restart
In-Reply-To: <4057DE34.1080001@zeut.net>
* 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