On Fri, Nov 4, 2011 at 12:07 PM, Claudio Freire <klaussfreire@gmail.com> wrote:
> What are those writes about? HOT vacuuming perhaps?
Every tuple lock requires dirtying the page. Those writes are all
those dirty pages getting flushed out to disk. It's possible that the
OS is allowing the writes to happen asynchronously for a while, but
then when you get too much dirty data in the cache, it starts
blocking.
The only thing I'm fuzzy about is why it's locking so many rows, given
that the output says rows=1.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company