Blog

| Monitoring Wait Events in PostgreSQL 9.6

Recently Robert Haas has committed a patch which allows seeing some more detailed information about current wait event of the process. In particular, user will be able to see if process is waiting for heavyweight lock, lightweight lock (either individual or tranche) or buffer pin. The full list of wait events is available in the documentation. Hopefully, it will be more wait events in further releases.

| Postgres developers (retrospective in pictures)

Oleg Bartunov: Today I have feeling, that our developers community needs some nostalgia.

| Beta-release of pg_pathman partitioning extension

pg_pathman is distributed as PostgreSQL 9.5 extension and available at github

| Scaling PostgreSQL at multicore Power8

Recently, we got  access to a big server: IBM 9119-MHE with 8 CPUs * 8 cores * 8 threads. We decided to take advantage of this and investigate the read scalability of postgres (pgbench -S) at this server.