WAL Performance Improvements

From: Janardhana Reddy <jana-reddy(at)mediaring(dot)com(dot)sg>
To: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Cc: janareddy <jana-reddy(at)mediaring(dot)com(dot)sg>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: WAL Performance Improvements
Date: 2002-02-25 05:09:16
Message-ID: 3C79C6FC.F6BB4471@mediaring.com.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi,
I've attached a patch which should improve the performance of WAL by
reducing the fsync time
and write time by 50%(if OS page size is 4k) , if the transaction
generate the WAL data less then 4k. Instead of
writing every time 8k data in to the WAL file it will write only the
portion of the data which
as changed from the last time(Example : if transaction generates 150
bytes of WAL data ,then it writes
only 150 bytes instead of 8k).

please apply for 7.3.

Regards
jana

Attachment Content-Type Size
patch_xlog text/plain 2.5 KB
xlog.c text/plain 96.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2002-02-25 05:10:03 Re: [HACKERS] Updated TODO item
Previous Message Christopher Kings-Lynne 2002-02-25 05:07:49 contrib module problems on freebsd/alpha

Browse pgsql-patches by date

  From Date Subject
Next Message Neil Conway 2002-02-25 05:10:03 Re: [HACKERS] Updated TODO item
Previous Message Bruce Momjian 2002-02-25 04:22:03 Re: Allow arbitrary levels of analyze/rewriting