Re: [PERFORM] BBU Cache vs. spindles

2010-10-23 Thread Kevin Grittner
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 WA

Re: [PERFORM] BBU Cache vs. spindles

2010-10-23 Thread Josh Berkus
Even if it's possible, it's far from clear to me that it would be an improvement. The author estimates (apparently somewhat loosely) that it's a 5% to 10% performance hit in InnoDB; I'm far from certain that full_page_writes cost us that much. Does anyone have benchmark numbers handy? It mos