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: (view raw, whole thread or download thread mbox)
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

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-2017 The PostgreSQL Global Development Group