Re: Chronic performance issue with Replication Failover and FSM. - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Chronic performance issue with Replication Failover and FSM.
Date
Msg-id 4F68F9A4.3080802@agliodbs.com
Whole thread Raw
In response to Re: Chronic performance issue with Replication Failover and FSM.  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Chronic performance issue with Replication Failover and FSM.  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: Gsoc2012 Idea --- Social Network database schema
Next
From: Alvaro Herrera
Date:
Subject: Re: patch for parallel pg_dump