Re: Version 7.2.3 Vacuum abnormality

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Version 7.2.3 Vacuum abnormality
Date: 2003-02-19 00:32:31
Message-ID: 7402.1045614751@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Sullivan <andrew(at)libertyrms(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-02-19 01:03:09 Re: psql and readline
Previous Message Tom Lane 2003-02-19 00:08:33 Re: Detecting corrupted pages earlier