Rob Wultsch wrote:
> I really would like to work with PG more and this seems like
> [full_page_writes] would be a significant hindrance for certain
> usage patterns. Lots of replication does not take place over gig...
Certainly most of the Wisconsin State Courts replication takes place
over WAN connections at a few Mbps. I haven't seen any evidence that
having full_page_writes on has caused us problems, personally.
In the PostgreSQL community you generally need to show some hard
numbers from a repeatable test case for the community to believe that
there's a problem which needs fixing, much less to buy in to some
particular fix for the purported problem. On the other hand, if you
can show that there actually *is* a problem, I've never seen a group
which responds so quickly and effectively to solve it as the
PostgreSQL community. Don't get too attached to a particular
solution without proof that it's better than the alternatives,
though....
-Kevin