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

RE: [GENERAL] Error during 'vacuum analyze'

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: Mark Dalphin <mdalphin(at)amgen(dot)com>, "pgsql-general(at)hub(dot)org" <pgsql-general(at)hub(dot)org>
Subject: RE: [GENERAL] Error during 'vacuum analyze'
Date: 1999-08-20 17:02:30
Message-ID: 37BD8A26.BED83813@nsi.edu (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Mark,

    The error you are experiencing was discussed on the hacker's list
last week. Oliver Elphick and Tom Good worked out a patch for SQL to
solve the problem. You're right that the pg_vlock is getting created and
then getting deleted during the vacuuming of the last table. This ends
up boinking the vacuum. I've attached the patch that Oliver sent to me.
The patch won't go through all of the way so you'll have to go through
file by file and just make the changes yourself (just deleting a few
lines or adding a few, nothing big). That has solved the problem on my
machine.

-Tony






Attachment: vacuumpatch.txt
Description: text/plain (4.5 KB)

Responses

pgsql-hackers by date

Next:From: LeonDate: 1999-08-20 18:28:17
Subject: Re: [HACKERS] Postgres' lexer
Previous:From: Dmitry SamersoffDate: 1999-08-20 16:37:18
Subject: What does it mean?

pgsql-general by date

Next:From: AlkeDate: 1999-08-20 20:51:07
Subject: OID and PL/pgSQL trigger :-(
Previous:From: F J CuberosDate: 1999-08-20 16:49:51
Subject: RE: [GENERAL] Problem accesing CVS tree

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