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