Gregory Stark wrote:
>
> "Simon Riggs" <simon@2ndquadrant.com> writes:
>
> > Asynchronous Commit allows some transactions to commit faster than
> > others, offering a trade-off between performance and durability for
> > specific transaction types only
>
> A lot of users will be confused about what asynchronous commit does. I think
> it's important to be consistently precise when describing it.
>
> It doesn't allow commits to be any faster, what it does is "allow clients to
> start a new transaction and continue working without waiting for their
> previous commit to complete". Saying something like "This allows high volumes
> of short transactions such as typical web sites to run more efficiently and
> with fewer connections" might also help clarify the use case it helps.
Well, logically the commit does happen faster in that your transaction
and others see the commit. It is just durability that is delayed.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
