Month: September 2017
Updates for the pgwatch2 Postgres monitoring tool
It’s been quite some time since I last wrote about our Open Source PostgreSQL monitoring tool called pgwatch2, but now there’s again a reason for it – it got a lot better again! Updates for the pgwatch2 Postgres monitoring tool include multiple new feature updates per requests from users and also some bugfixes. So this […]
Speeding up the creation of Postgres replicas
While it’s generally well known how to create physical replicas (i.e. block level copies), using the super simple and really effortless pg_basebackup tool, not so many know what can be done, when the process is painfully slow for bigger databases. The reason for slowness can be typically linked to machine hardware (slow disks, high CPU […]
Visualizing data in PostgreSQL with R Shiny
R is a free Open Source programming language and statistics package that is excellent for data analysis, statistics and graphics. It has been developed in the 90s and its community has steadily grown over the years. Developers and analysts can use R to analyze data from many different sources including PostgreSQL. This article shows, how […]