On Fri, Mar 27, 2009 at 10:32 AM, Will Rutherdale (rutherw)
<rutherw@cisco.com> wrote:
>
> Incidentally, in case people are interested in hearing the follow-up to
> my original message, my home-cooked benchmark with lots of processes
> doing tons of updates seemed to initially show MyISAM winning over
> Postgres.
>
> However I spent some time reading what I could from the manual on
> performance improvement and realized that commits might be an issue. I
> moved a commit() call out of the main loop, and bang! Postgres showed a
> substantial performance advantage over MyISAM.
This is one of those areas where postgresql acts very differently from
other dbs. In lots of other dbs big transactions are the performance
killer. In PostgreSQL big transactions are the way to get better
performace.