monitoring Archives - 2ndQuadrant

Posts

PG Phriday: Around the World in Two Billion Transactions

April 19, 2019/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Transaction IDs (XID) have been something of a thorn in Postgres’ side since the dawn of time. On one hand, they’re necessary to differentiate tuple visibility between past, present, and concurrent transactions. On the other hand, the counter that stores it is only 32-bits, meaning it’s possible to eventually overflow without some kind of intervention. […]

In the defense of sar (and how to configure it)

April 26, 2017/6 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

Let me discuss a topic that is not inherently PostgreSQL specific, but that I regularly run into while investigating issues on customer systems, evaluating “supportability” of those systems, etc. It’s the importance of having a monitoring solution for system metrics, configuring it reasonably, and why sar is still by far my favorite tool (at least […]

Autovacuum Tuning Basics

March 2, 2017/10 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas Vondra

A few weeks ago I covered the basics of tuning checkpoints, and in that post I also mentioned that the second common source of performance issues is autovacuum (based on what we see on the mailing list and at our customers under support). So let me follow-up on that with this post about the basics […]

pgFincore 1.2, une extension PostgreSQL

September 28, 2016/0 Comments/in Cedric's FR PlanetePostgreSQL, PostgreSQL /by Cédric Villemain

pgFincore 1.2 est une extension PostgreSQL pour auditer et manipuler le cache de pages de données du système d’exploitation. L’extension a déjà une histoire de 7 ans d’utilisation, avec des évolutions correspondant aux besoins de production. Télécharger ici la dernière version 1.2, compatible avec PostgreSQL 9.6.

How to check the lock level taken by operations in PostgreSQL

July 15, 2016/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

PostgreSQL’s manual is generally pretty clear about the locks taken by various operations – but nothing’s perfect. If you need to, you can also ask PostgreSQL directly. You can check lock levels trivially with psql or PgAdmin.

Barman 1.6.1 is Released

May 23, 2016/0 Comments/in Barman, Britt's PlanetPostgreSQL, International News /by Britt Cole

2ndQuadrant is proud to announce the release of Barman version 1.6.1, a Backup and Recovery Manager for PostgreSQL.

Redislog: Integrating PostgreSQL with Logstash for devops real-time monitoring

January 19, 2016/2 Comments/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

During the last October’s Italian PGDay and European PostgreSQL conference, my friend Marco Nenciarini and I had the pleasure to talk about a new open source plugin for PostgreSQL, called redislog. In that presentation (“Integrating PostgreSQL with Logstash for real-time monitoring”) we provided an example of our exploration/experimentation approach, with extensive and thorough coverage of […]

How monitoring of WAL archiving improves with PostgreSQL 9.4 and pg_stat_archiver

January 23, 2015/1 Comment/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

PostgreSQL 9.4 introduces a new statistic in the catalogue, called pg_stat_archiver. Thanks to the SQL language it is now possible, in an instant, to check the state of the archiving process of transactional logs (WALs), crucial component of a PostgreSQL disaster recovery system.

Detecting smelly backups with Barman

August 27, 2014/0 Comments/in Barman, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

“Ooooh that smell! Can’t you smell that smell?“. That’s a classic rock song by legends Lynyrd Skynyrd, I know. But also a warning that your new Barman 1.3.3 installation can now emit.