> Now, with ext4 moving to full barrier/fsync support, we could get to the
> point where WAL in the main data FS can mimic the state where WAL is
> seperate, namely that WAL writes can "jump the queue" and be written
> without waiting for the data pages to be flushed down to disk, but also
> that you'll get the big backlog of data pages to flush when
> the first fsyncs on big data files start coming from checkpoints...
Does postgres write something to the logfile whenever a fsync() takes a
suspiciously long amount of time ?
In response to
pgsql-performance by date
|Next:||From: Scott Marlowe||Date: 2010-01-21 16:41:19|
|Subject: Re: New server to improve performance on our large and busy DB - advice?|
|Previous:||From: Florian Weimer||Date: 2010-01-21 16:24:12|
|Subject: Re: Inserting 8MB bytea: just 25% of disk perf used?|