Robert Haas <robertmh...@gmail.com> writes:
> [ lots of interesting stuff about WAL optimization snipped ]

> ... Second, they aren't really using locks, unless you count
> bus locks - they appear to have implemented most or all of it via
> CAS-based lock-free algorithms, which is probably well-justified
> optimization effort.

FWIW, I'm pretty suspicious of claims that lock-free data structures
will be some kind of magic bullet.  As far as I can tell, a very large
part of our contention problems on many-core machines stem from the CPUs
fighting over cache line ownership.  Avoiding an explicit lock in favor
of hardware primitive test-and-modify instructions isn't going to do a
darn thing to improve that.  And contorting the algorithms until they
fit into what's portably available in that line could easily be a net
loss.

                        regards, tom lane

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to