Re: [pgsql-advocacy] 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly