Re: Chronic performance issue with Replication Failover and FSM.

Heikki,

> The FSM is included in the base backup, and it is updated when VACUUM
> records are replayed.

Oh?  Hmmmm.   In that case, the issue I'm seeing in production is
something else.  Unless that was a change for 9.1?

> It is also updated when insert/update/delete records are replayed,
> athough there's some fuzziness there: records with full page images
> don't update the FSM, and the FSM is only updated when the page has less
> than 20% of free space left. But that would cause an error in the other
> direction, with the FSM claiming that some pages have more free space
> than they do in reality.

Thanks.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com