pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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 





view thread (7+ messages)  latest in thread

Message-ID: <00ed01c780c5$91dd2390$0b02a8c0@KieranX15>
Permalink:  ../00ed01c780c5$91dd2390$0b02a8c0@KieranX15/
Also on:    postgresql.org/message-id/00ed01c780c5$91dd2390$0b02a8c0@KieranX15

 · 

reply

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