Re: max_fsm_pages >800k ... ?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: max_fsm_pages >800k ... ?
Date: 2005-06-15 18:18:50
Message-ID: 200506151118.50625.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Marc,

> Without more information to provide at this time, does the following
> seem "unusual"?
>
> INFO: free space map: 252 relations, 411494 pages stored; 738640 total
> pages needed DETAIL: Allocated FSM size: 2000 relations + 400000 pages
> = 2463 kB shared memory.

Looks like you haven't run VACUUM in a few days. Or like you deleted and
re-loaded a large table multiple times.

BTW, this is really more of a pgsql-performance question ...

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2005-06-15 18:32:32 Re: Add PG version number to NLS files
Previous Message Stefan Kaltenbrunner 2005-06-15 18:08:32 Re: Gist Recovery testing