From: Amit Kapila <amit.kapila@huawei.com>
To: 'Ants Aasma' <ants@cybertec.at>
Cc: 'Greg Smith' <greg@2ndquadrant.com>
Cc: 'Heikki Linnakangas' <hlinnakangas@vmware.com>
Cc: 'PostgreSQL-development' <pgsql-hackers@postgresql.org>
Cc: 'KONDO Mitsumasa' <kondo.mitsumasa@lab.ntt.co.jp>
Subject: Re: Improvement of checkpoint IO scheduler for stable transaction responses
Date: Thu, 18 Jul 2013 16:50:43 +0530
Message-ID: <005d01ce83a8$d8a6fd90$89f4f8b0$@kapila@huawei.com> (raw)
In-Reply-To: <CA+CSw_uDvbBUwESoR6LN3yM5pAPYrrWWZPTHaffAoQkVg5AcKg@mail.gmail.com>
References: <51B5AFB1.5030404@lab.ntt.co.jp>
<51BDCB6C.1090507@vmware.com>
<51E2F1C4.6010503@2ndQuadrant.com>
<CA+CSw_ta4s_gLGnAH4GQyvLdc8LAWgFJXhS7Y-Lwt5tZOHz_9g@mail.gmail.com>
<51e687de.ea06980a.04fe.332eSMTPIN_ADDED_BROKEN@mx.google.com>
<CA+CSw_uDvbBUwESoR6LN3yM5pAPYrrWWZPTHaffAoQkVg5AcKg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
On Wednesday, July 17, 2013 6:08 PM Ants Aasma wrote:
> On Wed, Jul 17, 2013 at 2:54 PM, Amit Kapila <amit.kapila@huawei.com>
> wrote:
> > I think Oracle also use similar concept for making writes efficient,
> and
> > they have patent also for this technology which you can find at below
> link:
> >
> http://www.google.com/patents/US7194589?dq=645987&hl=en&sa=X&ei=kn7mUZ-
> PIsWq
> > rAe99oDgBw&sqi=2&pjf=1&ved=0CEcQ6AEwAw
> >
> > Although Oracle has different concept for performing checkpoint
> writes, but
> > I thought of sharing the above link with you, so that unknowingly we
> should
> > not go into wrong path.
> >
> > AFAIK instead of depending on OS buffers, they use direct I/O and
> infact in
> > the patent above they are using temporary buffer (Claim 3) to sort
> the
> > writes which is not the same idea as far as I can understand by
> reading
> > above thread.
>
> They are not even sorting anything, the patent is for
> opportunistically looking for adjacent dirty blocks when writing out a
> dirty buffer to disk. While a useful technique, this has nothing to do
> with sorting checkpoints.
It is not sorting, rather it finds consecutive blocks before writing to disk
using hashing in buffer cache.
I think the patch is different from it in multiple ways.
I had read this patent some time back and thought that you are also trying
to achieve something similar (Reduce random I/O),
so shared with you.
With Regards,
Amit Kapila.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: amit.kapila@huawei.com, ants@cybertec.at, greg@2ndquadrant.com, hlinnakangas@vmware.com, kondo.mitsumasa@lab.ntt.co.jp
Subject: Re: Improvement of checkpoint IO scheduler for stable transaction responses
In-Reply-To: <005d01ce83a8$d8a6fd90$89f4f8b0$@kapila@huawei.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox