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

Re: Spread checkpoint sync

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Spread checkpoint sync
Date: 2010-12-02 19:48:54
Message-ID: 4CF7F826.1060301@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> Using sync_file_range you can specify the set of blocks to sync and
> then block on them only after some time has passed. But there's no
> documentation on how this relates to the I/O scheduler so it's not
> clear it would have any effect on the problem. We might still have to
> delay the begining of the sync to allow the dirty blocks to be synced
> naturally and then when we issue it still end up catching a lot of
> other i/o as well.

This *really* sounds like we should be working with the FS geeks on
making the OS do this work for us.  Greg, you wanna go to LinuxCon next
year?

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2010-12-02 19:52:27
Subject: Re: directory archive format for pg_dump
Previous:From: Greg StarkDate: 2010-12-02 19:24:13
Subject: Re: Spread checkpoint sync

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