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 |
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 |
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 |