Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0 - Mailing list pgsql-patches

From Tom Lane
Subject Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0
Date
Msg-id 10317.1168638117@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Corrupt database? 8.1/FreeBSD6.0  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane wrote:
>> Alvaro Herrera <alvherre@commandprompt.com> writes:
>>> Ok, it does what it's intended to do.  But in testing it I also
>>> confirmed that a database-wide vacuum creates a pgstat entry for it and
>>> for all tables in it.  Is this something we want to prevent?
>>
>> That's odd, because I didn't see any such thing when I tested in CVS tip
>> the other day.  Or did you have stats_block_level turned on?

> Yes, I turned it on for this test.

Well, the vacuums certainly accounted for I/O, so I suppose this is
reasonable behavior.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bill Moran
Date:
Subject: Re: [PATCHES] Patch to log usage of temporary files
Next
From: Neil Conway
Date:
Subject: Re: [HACKERS] NaN behavior