Postgres Pro
Downloads
Home   >   mailing lists

Re: Version 7.2.3 Vacuum abnormality - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Version 7.2.3 Vacuum abnormality
Date
Msg-id 7402.1045614751@sss.pgh.pa.us
Whole thread Raw
In response to Re: Version 7.2.3 Vacuum abnormality  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-hackers
Tree view 
Andrew Sullivan <andrew@libertyrms.info> writes:
> On Mon, Feb 17, 2003 at 05:42:21PM -0500, Tom Lane wrote:
>> The mechanism I described in the above-referenced message only occurs
>> for nailed-in-cache system tables.  Given Daniels' report (and one or

> And for ones that have been truncated?  I found this reference:

>
<http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&threadm=200301251026.14193.mallah%40trade-india.com&rnum=5&prev=/groups%3Fq%3DUninitialized%2Bpage%2Bgroup:comp.databases.postgresql.*%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3D200301251026.14193.mallah%2540trade-india.com%26rnum%3D5>

Sigh, I must be losing brain cells faster than I thought.  I completely
forgot about the TRUNCATE version of the problem.

Of course, if the complainant hasn't done TRUNCATE either, then we may
still have an issue ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Detecting corrupted pages earlier
Next
From: Bruce Momjian
Date:
Subject: Re: psql and readline