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

Re: VACUUM causes violent postmaster death

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Dan Moschuk <dan(at)freebsd(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: VACUUM causes violent postmaster death
Date: 2000-11-03 23:57:18
Message-ID: 20001103155718.D5112@fw.wintelcom.net (view raw or flat)
Thread:
Lists: pgsql-hackers
* Dan Moschuk <dan(at)freebsd(dot)org> [001103 15:32] wrote:
> 
> | > This happens fairly regularly.  I assume exit code 26 is used to dictate
> | > that a specific error has occured.
> | > 
> | > The database is a decent size (~3M records) with about 4 indexes.
> | 
> | What version of postgresql?  Tom Lane recently fixed some severe problems
> | with vacuum and heavily used databases, the fix should be in the latest
> | 7.0.2-patches/7.0.3 release.
> 
> It's 7.0.2-patches from about two or three weeks ago.

Make sure pgsql/src/backend/commands/vacuum.c is at:

revision 1.148.2.1
date: 2000/09/19 21:01:04;  author: tgl;  state: Exp;  lines: +37 -19
Back-patch fix to ensure that VACUUM always calls FlushRelationBuffers.

-- 
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."

In response to

Responses

pgsql-hackers by date

Next:From: Alfred PerlsteinDate: 2000-11-04 00:00:41
Subject: Re: Alpha FreeBSD port of PostgreSQL !!!
Previous:From: Peter EisentrautDate: 2000-11-03 23:37:13
Subject: Re: problems with configure

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