PERFORMANCE IMPROVEMENT by mapping WAL FILES

From: Janardhana Reddy <jana-reddy(at)mediaring(dot)com(dot)sg>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, janareddy <jana-reddy(at)mediaring(dot)com(dot)sg>
Subject: PERFORMANCE IMPROVEMENT by mapping WAL FILES
Date: 2001-09-26 11:23:27
Message-ID: 3BB1BAAF.256C3DDB@mediaring.com.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,
By mapping the WAL files by each backend in to its address
space using "mmap" system call , there will be big
improvements in performance from the following point of view:
1. Each backend directly writes in to the address
space which is obtained by maping the WAL files.
this saves the write system call at the end of
every transaction which transfres 8k of
data from user space to kernel.
2. since every transaction does not modify all the 8k
content of WAL page , so by issuing the
fsync , the kernel only transfers only the
kernel pages which are modified , which is 4k for
linux so fsync time is saved by twice.
Any comments ?.

Regards
jana

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mlw 2001-09-26 11:50:25 Re: Converting from pgsql to sqlserver?
Previous Message armindo.dias 2001-09-26 11:04:27 Converting from pgsql to sqlserver?