Re: Press Release review comments

"Robert Treat" <xzilla@users.sourceforge.net> writes:

> Simon, have you tested async_commit performance with any of the the beta
> releases?  I was involved in a conversation on irc the other day that had
> some anecdotale reports that async_commit was not giving significant speed
> benfits, perhaps as a result of the other tuning and work that has gone into
> the release later in the development cycle. I've not had chance to verify
> this info, so I was wondering if you had.

It depends a lot on your workload. If you have many parallel connections
keeping the i/o controller busy you might not see much change. Alternately if
you have large updates then the 5-15ms waiting for fsync may make little
impact.

Where it helps a lot is on workloads like simple web applications which flood
the server with tons of short updates on a handful of connections.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning