Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance

Поиск
Список
Период
Сортировка
Искать
От
Kevin Grittner
Тема
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance
Дата
Msg-id
4CADC97A0200002500036662@gw.wicourts.gov
Ответ на
Список
Дерево обсуждения
MIT benchmarks pgsql multicore (up to 48)performance Hakan Kocaman <hkocam@googlemail.com>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Dan Ports <drkp@csail.mit.edu>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Josh Berkus <josh@agliodbs.com>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Ivan Voras <ivoras@freebsd.org>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Ivan Voras <ivoras@freebsd.org>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Ivan Voras <ivoras@freebsd.org>
Re: [HACKERS] MIT benchmarks pgsql multicore (up to 48)performance Jon Nelson <jnelson+pgsql@jamponi.net>
Re: MIT benchmarks pgsql multicore (up to 48)performance Scott Marlowe <scott.marlowe@gmail.com>
Stephen Frost  wrote: 
> Kevin Grittner (Kevin.Grittner@wicourts.gov) wrote:
>> Robert Haas  wrote:
 
>>> perhaps it would be possible by, say, increasing the number of
>>> lock partitions by 8x.
 
>> changing this 4 to a 7?:
>>  
>> #define LOG2_NUM_LOCK_PARTITIONS  4
 
> I'm pretty sure we were talking about the change described in the
> paper of moving to a system which uses atomic changes instead of
> spinlocks for certain locking situations..
 
Well, they also mentioned increasing the number of lock partitions
to reduce contention, and that seemed to be what Robert was talking
about in the quoted section.
 
Of course, that's not the *only* thing they did; it's just the point
which seemed to be under discussion just there.
 
-Kevin
В списке pgsql-performance по дате отправления
От: Stephen Frost
Дата:
От: Dan Harris
Дата:
FAQ