Re: ext4 finally doing the right thing

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: ext4 finally doing the right thing
Date: 2010-01-22 00:13:01
Message-ID: 4B58ED8D.2040804@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Pierre Frédéric Caillaud wrote:
>
> Does postgres write something to the logfile whenever a fsync()
> takes a suspiciously long amount of time ?

Not specifically. If you're logging statements that take a while, you
can see this indirectly, but commits that just take much longer than usual.

If you turn on log_checkpoints, the "sync time" is broken out for you,
problems in this area can show up there too.

--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2010-01-22 03:22:36 Re: Slow update query
Previous Message Greg Smith 2010-01-22 00:10:40 Re: TPC-C implementation for postgresql?