Skip site navigation (1) Skip section navigation (2)

Re: Vacuum stops with misleading max_fsm_pages error

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: "Kieran Cooper, Lyris UK" <kieran(at)lyris(dot)co(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum stops with misleading max_fsm_pages error
Date: 2007-04-16 22:14:38
Message-ID: 4623F54E.3030900@zeut.net (view raw or flat)
Thread:
Lists: pgsql-admin
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?

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2007-04-16 22:36:26
Subject: Re: Vacuum stops with misleading max_fsm_pages error
Previous:From: Joshua D. DrakeDate: 2007-04-16 22:08:54
Subject: Re: Vacuum stops with misleading max_fsm_pages error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group