| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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 | Content-Type | Size |
|---|---|---|
| vacuumpatch.txt | text/plain | 4.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alke | 1999-08-20 20:51:07 | OID and PL/pgSQL trigger :-( |
| Previous Message | F J Cuberos | 1999-08-20 16:49:51 | RE: [GENERAL] Problem accesing CVS tree |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leon | 1999-08-20 18:28:17 | Re: [HACKERS] Postgres' lexer |
| Previous Message | Dmitry Samersoff | 1999-08-20 16:37:18 | What does it mean? |