Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)us] wrote:
> At the very end ... you're looking for these messages:
> (errmsg("free space map contains %d pages in %d relations",
> storedPages, numRels),
> errdetail("A total of %.0f page slots are in use (including
> "%.0f page slots are required to track all free space.\n"
> "Current limits are: %d page slots, %d relations, using %.0f
> Min(needed, MaxFSMPages),
> MaxFSMPages, MaxFSMRelations,
> (double) FreeSpaceShmemSize() / 1024.0)));
> if (numRels == MaxFSMRelations)
> (errmsg("max_fsm_relations(%d) equals the number of
> relations checked",
> errhint("You have at least %d relations. "
> "Consider increasing the configuration
> parameter \"max_fsm_relations\".",
> else if (needed > MaxFSMPages)
> (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'
I've already posted the tail of this output previously.
I conclude that these lines are not in this file. Where
did they go?
pgsql-general by date
|Next:||From: Erik Jones||Date: 2008-04-25 00:45:14|
|Subject: Re: Confused by result of pg_catalog.format_type() |
|Previous:||From: Tom Lane||Date: 2008-04-25 00:34:53|
|Subject: Re: query performance |