Re: [PERFORM] Newbie performance problem - semop taking most of time ?

CPU on the server shows approx 60% used/40 % idle vmstat 5 5 procs ---memory-- ---swap-- -io --system-- -cpu- r b swpd free buff cache si sobibo in cs us sy id wa st 18 0 0 160465072 455200 3521852480037 42120

[PERFORM] Newbie performance problem - semop taking most of time ?

Using postgreSQL 9.2 with the following settings: max_connections = 1000 # (change requires restart) shared_buffers = 65536MB# min 128kB work_mem = 16MB # min 64kB effective_io_concurrency = 48 # 1-1000; 0 disables prefetching wal_