Re: Double entries in log for page slots in beta3

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Ron Mayer" <rm_pg(at)cheapcomplexdevices(dot)com>, <pgsql-hackers(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Double entries in log for page slots in beta3
Date: 2006-11-28 21:48:08
Message-ID: 456C5A38.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>> On Tue, Nov 28, 2006 at 3:37 PM, in message
<456CAC0E(dot)3090409(at)cheapcomplexdevices(dot)com>, Ron Mayer
<rm_pg(at)cheapcomplexdevices(dot)com> wrote:
> Tom Lane wrote:
>> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
>>> One exceedingly minor logging issue I just noticed in looking at
the log
>>> from a beta3.
>>
>> Yeah, this is someone's idea of a feature:
>>
>> CheckFreeSpaceMapStatistics(NOTICE, numRels, needed);
>> /* Print to server logs too because is deals with a config
variable. */
>> CheckFreeSpaceMapStatistics(LOG, numRels, needed);
>>
>> I thought it was a crock when it was put in, but lost the argument.
>
> If there's a better way for me to be managing this, let me know
> and I'll happily withdraw my requests that the message be spewed
> twice.

I've generally been capturing the output of my nightly VACUUM ANALYZE
VERBOSE run, and looking for this information at the end of that file.

> the only reason I
> still have a scheduled database- wide- vacuum is for this FSM
message.

Isn't it necessary to do this periodically to prevent transaction ID
wraparound?

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-11-28 21:51:25 Re: [COMMITTERS] pgsql: Fix some translator comments so that
Previous Message Peter Eisentraut 2006-11-28 21:46:21 Re: [COMMITTERS] pgsql: Fix some translator comments so that xgettext finds them and