Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: xlog.c
Description: text/plain (96.8 KB)
Attachment: patch_xlog
Description: text/plain (2.5 KB)

Responses

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group