Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group