Re: [PERFORM] unusual performance for vac following 8.2 upgrade - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PERFORM] unusual performance for vac following 8.2 upgrade
Date
Msg-id 6871.1168554415@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PERFORM] unusual performance for vac following 8.2 upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PERFORM] unusual performance for vac following 8.2 upgrade  (Kim <kim@myemma.com>)
List pgsql-hackers
I wrote:
> (2) Reconsider whether last-vacuum-time should be sent to the collector
> unconditionally.

Actually, now that I look, the collector already contains this logic:

    /*
     * Don't create either the database or table entry if it doesn't already
     * exist.  This avoids bloating the stats with entries for stuff that is
     * only touched by vacuum and not by live operations.
     */

and ditto for analyze messages.  So my idea that the addition of
last-vac-time was causing an increase in the statistics file size
compared to 8.1 seems wrong.

How large is your $PGDATA/global/pgstat.stat file, anyway?

            regards, tom lane

pgsql-hackers by date:

Previous
From: Michael Enke
Date:
Subject: copy table from file: with row replacement?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Some notes about redesigning planner data structures