From: Kieran Cooper, Lyris UK <kieran@lyris.co.uk>
To: Matthew T. O'Connor <matthew@zeut.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: Vacuum stops with misleading max_fsm_pages error
Date: Tue, 17 Apr 2007 08:51:46 +0100
Message-ID: <00ed01c780c5$91dd2390$0b02a8c0@KieranX15> (raw)
References: <001901c78071$9a9a1f00$0b02a8c0@KieranX15>
<4623F54E.3030900@zeut.net>
> Kieran Cooper, Lyris UK wrote:
>> We're managing a database on version 8.2.3 (running Lyris ListManager
>> email software). I ran a 'vacuum analyze full verbose' (we haven't been
>> able to get autovacuum to work properly on Lyris installs so we need to
>> run a full vacuum every week or so, and we'd been doing some work on this
>> machine so it needed it). It ran happily for quite a while - about 2
>> thirds of the way through the database - but then ended with the lines
>
>
> What is it about autovacuum that isn't working for you?
Hi Matthew. I have to admit that I haven't tested full yet, but here's the
scenario:
When Lyris sends a mailing there is an intense amount of database activity -
particularly on two tables. When I had auto vacuum set up, the database just
wasn't responding fast enough, so the mailing speed dropped as Lyris
dynamically adjusted based on the speed of db response. I guess what I need
to do is tweak the intervals and the sleep time so that vacuum backs off
when the database is really busy - do you have any thoughts on what settings
I should try in order to acheive that?
Thanks so much
Kieran
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-admin@postgresql.org
Cc: kieran@lyris.co.uk, matthew@zeut.net
Subject: Re: Vacuum stops with misleading max_fsm_pages error
In-Reply-To: <00ed01c780c5$91dd2390$0b02a8c0@KieranX15>
* 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