pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matthew O'Connor <matthew@zeut.net>
To: Kieran Cooper, Lyris UK <kieran@lyris.co.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: Vacuum stops with misleading max_fsm_pages error
Date: Tue, 17 Apr 2007 09:13:09 -0400
Message-ID: <4624C7E5.7060506@zeut.net> (raw)
In-Reply-To: <00ed01c780c5$91dd2390$0b02a8c0@KieranX15>
References: <001901c78071$9a9a1f00$0b02a8c0@KieranX15>
	<4623F54E.3030900@zeut.net>
	<00ed01c780c5$91dd2390$0b02a8c0@KieranX15>

Kieran Cooper, Lyris UK wrote:
>> 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?


The sleep intervals are one thing, but what you probably really want to 
play with are they vacuum cost delay and limit settings.  This is 
throttle down how much IO autovacuum can consume.

http://www.postgresql.org/docs/8.2/interactive/runtime-config-autovacuum.html



view thread (7+ messages)

Message-ID: <4624C7E5.7060506@zeut.net>
Permalink:  ../4624C7E5.7060506@zeut.net/
Also on:    postgresql.org/message-id/4624C7E5.7060506@zeut.net

 · 

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: matthew@zeut.net, kieran@lyris.co.uk
  Subject: Re: Vacuum stops with misleading max_fsm_pages error
  In-Reply-To: <4624C7E5.7060506@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