Proposal of PITR performance improvement for 8.4.

From: "Koichi Suzuki" <koichi(dot)szk(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Proposal of PITR performance improvement for 8.4.
Date: 2008-10-28 07:33:03
Message-ID: a778a7260810280033n43f70d36x8c437eacf9a5461e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

This is my first proposal of PITR performance improvement for
PostgreSQL 8.4 development. This proposal includes readahead
mechanism of data pages which will be read by redo() routines in the
recovery. This is especially effective in the recovery without full
page write. Readahead is done by posix_fadvise() as proposed in
index scan improvement.

Details of the implementation will be found in README file in the material.

--
------
Koichi Suzuki

Attachment Content-Type Size
pg_readahead_20081028.tar.gz application/x-gzip 11.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2008-10-28 07:58:10 Re: Window Functions: v07 APIs and buffering strateties
Previous Message Hitoshi Harada 2008-10-28 07:03:30 Re: Window Functions: v07 APIs and buffering strateties