Skip site navigation (1) Skip section navigation (2)

Re: query performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Cox <brian(dot)cox(at)ca(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: query performance
Date: 2008-04-25 00:34:53
Message-ID: 11185.1209083693@sss.pgh.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-general
Brian Cox <brian(dot)cox(at)ca(dot)com> writes:
> Any hints as to where the FSM info is in this file?

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

In response to

pgsql-general by date

Next:From: Brian CoxDate: 2008-04-25 00:41:26
Subject: Re: query performance
Previous:From: Brian CoxDate: 2008-04-25 00:33:52
Subject: Re: query performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group