On 2016-03-25 18:11:21 +0800, 657985...@qq.com wrote: > hello everyone: > I was bothered by the postgres spinlock for a long time . How to > understand this sentence "postgres 9.5 performance improvements for multi-CPU > machines" > at present my database is 9.3.5 。 Can it solve the spinlock problem, if > upgrade it to 9.5 ?
It's quite possible that the upgrade helps. But without additional data it's hard to say. The change is that postgres internal reader/writer lock now, in many cases, avoid the use of a spinlock, relying on atomic operations instead. Regards, Andres -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
