Re: query performance

Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)us] wrote:

> At the very end ... you're looking for these messages:
>
> ereport(elevel,
> (errmsg("free space map contains %d pages in %d relations",
> storedPages, numRels),
> errdetail("A total of %.0f page slots are in use (including
> overhead).\n"
> "%.0f page slots are required to track all free space.\n"
> "Current limits are: %d page slots, %d relations, using %.0f
> kB.",
> Min(needed, MaxFSMPages),
> needed,
> MaxFSMPages, MaxFSMRelations,
> (double) FreeSpaceShmemSize() / 1024.0)));
>
> if (numRels == MaxFSMRelations)
> ereport(elevel,
> (errmsg("max_fsm_relations(%d) equals the number of
> relations checked",
> MaxFSMRelations),
> errhint("You have at least %d relations. "
> "Consider increasing the configuration
> parameter \"max_fsm_relations\".",
> numRels)));
> else if (needed > MaxFSMPages)
> ereport(elevel,
> (errmsg("number of page slots needed (%.0f) exceeds
> max_fsm_pages (%d)",
> needed, MaxFSMPages),
> errhint("Consider increasing the configuration
> parameter \"max_fsm_pages\" "
> "to a value over %.0f.", needed)));
>
> regards, tom lane
>

The following greps of the vacuum verbose output return no lines:

fgrep -i fsm
fgrep 'free space'
fgrep 'page slots'
fgrep 'relations'

I've already posted the tail of this output previously.
I conclude that these lines are not in this file. Where
did they go?

Thanks,
Brian