What can we improve if we have a battery-backed-disk?

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: What can we improve if we have a battery-backed-disk?
Date: 2006-06-16 02:48:58
Message-ID: e6t673$1dkj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


When I read the post related to the battery-backed disks, I come to this
question: What can we improve/reduce if we have them? Since our fsync
methods is already be able support that (thought not automatically), we may
want to look into other parts. One issue is the xlog and our aim is (1)
reduce xlog write requests/size (2) make commit faster.

The key is the number of pages changed by an atomic operation. For
operations change only 1 page, then we can assert that if you have written
the page, you are safe. So for buffer flush, if we know that this page is
the only page changed in atomic operations (no matter how many), we just
issue the write without xlog then it is done. For commit, we may have an
alternative to just write this page without any xlog flush. Of course, this
is a tradeoff, which may impose even bigger cost on commit due to
sizeof(page) vs. sizeof(xlog record), but we may win back the xlog replay
time.

Comments?

Regards,
Qingqing

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-06-16 03:14:06 Re: Test request for Stats collector performance improvement
Previous Message Toru SHIMOGAKI 2006-06-16 02:45:37 Re: Parallel index build during COPY