Re: MMAP performance and using mmap writes

2018-11-30 Thread Bron Gondwana
On Sat, 1 Dec 2018, at 01:32, Дилян Палаузов wrote: > Hello, > > > > 3: if your DB is larger than RAM, writing thru mmap is slower than using > > > write() syscalls. Whenever you > > > access a page for the first time, the OS will page it in. This is a > > > wasted I/O if all you're doin

Re: MMAP performance and using mmap writes

2018-11-30 Thread Дилян Палаузов
Hello, > > 3: if your DB is larger than RAM, writing thru mmap is slower than using > > write() syscalls. Whenever you > > access a page for the first time, the OS will page it in. This is a wasted > > I/O if all you're doing is > > overwriting the page with new data. > > I doubt it... especial

Re: MMAP performance and using mmap writes

2018-11-30 Thread Bron Gondwana
On Fri, Nov 30, 2018, at 22:09, Howard Chu wrote: > Bron Gondwana wrote: > > Hi All, > > > > We were debugging the CPU usage in a ctl_conversationsdb rebuild yesterday, > > and noticed an interesting thing. 70% of the CPU utilisation for this one > > process > > was inside the kernel! Mostl

Re: MMAP performance and using mmap writes

2018-11-30 Thread Howard Chu via Cyrus-devel
Bron Gondwana wrote: > Hi All, > > We were debugging the CPU usage in a ctl_conversationsdb rebuild yesterday, > and noticed an interesting thing.  70% of the CPU utilisation for this one > process > was inside the kernel!  Mostly with dirty pages. > > ctl_conversationsdb -R is particularly hea