Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V1D43-0001hH-9g for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jul 2013 10:09:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1V1D42-0001zW-OT for pgsql-hackers@arkaria.postgresql.org; Mon, 22 Jul 2013 10:09:58 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V1D41-0001zQ-Ii for pgsql-hackers@postgresql.org; Mon, 22 Jul 2013 10:09:57 +0000 Received: from tama50.ecl.ntt.co.jp ([129.60.39.147]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1V1D3y-0007wW-1L for pgsql-hackers@postgresql.org; Mon, 22 Jul 2013 10:09:56 +0000 Received: from mfs6.rdh.ecl.ntt.co.jp (mfs6.rdh.ecl.ntt.co.jp [129.60.39.149]) by tama50.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id r6MA9fSl003240; Mon, 22 Jul 2013 19:09:41 +0900 Received: from mfs6.rdh.ecl.ntt.co.jp (localhost.localdomain [127.0.0.1]) by mfs6.rdh.ecl.ntt.co.jp (Postfix) with ESMTP id CFFE0E0132; Mon, 22 Jul 2013 19:09:41 +0900 (JST) Received: from imail3.m.ecl.ntt.co.jp (imail3.m.ecl.ntt.co.jp [129.60.5.248]) by mfs6.rdh.ecl.ntt.co.jp (Postfix) with ESMTP id BA968E0130; Mon, 22 Jul 2013 19:09:41 +0900 (JST) Received: from [129.60.241.67] ([129.60.241.67]) by imail3.m.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id r6MA9fvJ001354; Mon, 22 Jul 2013 19:09:41 +0900 Message-ID: <51ED05F2.3090400@lab.ntt.co.jp> Date: Mon, 22 Jul 2013 19:14:10 +0900 From: KONDO Mitsumasa User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130620 Thunderbird/17.0.7 MIME-Version: 1.0 To: Heikki Linnakangas CC: Greg Smith , didier , Robert Haas , PostgreSQL-development Subject: Re: Improvement of checkpoint IO scheduler for stable transaction responses References: <51B5AFB1.5030404@lab.ntt.co.jp> <51BDCB6C.1090507@vmware.com> <51BEB6F5.7070907@lab.ntt.co.jp> <51C40EF4.1080201@lab.ntt.co.jp> <51C9D03B.10107@vmware.com> <51C9FD5C.5050706@vmware.com> <51E2F865.8030406@2ndQuadrant.com> <51E80CBC.10204@2ndQuadrant.com> <51E8F080.4040506@lab.ntt.co.jp> <51E943A1.9030702@2ndQuadrant.com> <51EABACA.70701@2ndQuadrant.com> <51EAE6F1.1010402@vmware.com> In-Reply-To: <51EAE6F1.1010402@vmware.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.5 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org (2013/07/21 4:37), Heikki Linnakangas wrote: > Mitsumasa-san, since you have the test rig ready, could you try the attached > patch please? It scans the buffer cache several times, writing out all the dirty > buffers for segment A first, then fsyncs it, then all dirty buffers for segment > B, and so on. The patch is ugly, but if it proves to be helpful, we can spend the > time to clean it up. Thank you! It is interesting code, I test it. By the way, my campany's colleague helps us to testing. If you have other idea, please send me patch or methods. Best regards, -- Mitsumasa KONDO -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers