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
Дата: