PERFORMANCE IMPROVEMENT by mapping WAL FILES

Поиск
Список
Период
Сортировка
От Janardhana Reddy
Тема PERFORMANCE IMPROVEMENT by mapping WAL FILES
Дата
Msg-id 3BB1BAAF.256C3DDB@mediaring.com.sg
обсуждение исходный текст
Ответы Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES
Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES
Список pgsql-hackers
Hi all,         By   mapping  the WAL files by each backend  in to its address
space  using "mmap"  system call , there  will be  bigimprovements  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
everytransaction 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: armindo.dias@dhvmc.pt
Дата:
Сообщение: Converting from pgsql to sqlserver?
Следующее
От: mlw
Дата:
Сообщение: Re: Converting from pgsql to sqlserver?