[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freebsd-fs
Subject:    lseek() scalability and PostgreSQL
From:       Ivan Voras <ivoras () freebsd ! org>
Date:       2011-11-27 19:09:34
Message-ID: jau1tg$vib$1 () dough ! gmane ! org
[Download RAW message or body]

Interesting tidbit from PostgreSQL optimization:

http://rhaas.blogspot.com/2011/11/linux-lseek-scalability.html

"""
PostgreSQL calls lseek quite frequently (to determine the file length, 
not to actually move the file pointer), and due to the performance 
enhancements in 9.2devel, it's now much easier to hit the contention 
problems that can be caused by frequently acquiring and releasing the 
inode mutex.  But it looks like this should be fixed in Linux 3.2, which 
is now at rc1, and therefore on track to be released well before 
PostgreSQL 9.2.
"""

It looks like this might cause some of the things I've observed on 
many-core servers.

_______________________________________________
freebsd-fs@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-fs
To unsubscribe, send any mail to "freebsd-fs-unsubscribe@freebsd.org"
[prev in list] [next in list] [prev in thread] [next in thread]