* Dan Moschuk <dan@freebsd.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@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."
