When teaching PostgreSQL trainings, both on basics and advanced topics, I often find out the attendees have very little idea how powerful the expression indexes may be (if they are...
PostgreSQL’s Release Management Team is requesting your input on patches that are most likely to cause bugs or instability. I’m sure you have an opinion on that! Please cast your...
After months of efforts, I’m pleased that Postgres-XL 9.5r1 is seeing the daylight. It has been tremendous collective efforts by many, both inside and outside 2ndQuadrant . Often it’s not...
Many years ago, Michelle Caise submitted a patch to generate code coverage reports for the PostgreSQL code base, based on the lcov utility. Although I cannot find any record of...
If you try to create an LVM snapshot with lvm lvcreate -s -n snapname -L 100G myvg and it fails with Unable to create a snapshot smaller than 2 chunks...
Last week I was invited by the Dutch PostgreSQL User Group in Amsterdam to speak on PostgreSQL Administration Recipes. It was the first session of 2016, and the third since...
Sharding or horizontal scalability is a popular topic, discussed widely on PostgreSQL mailing lists these days. When we started the Postgres-XC project back in 2010, not everyone was convinced that...
Good news has come out to ensure your disaster recovery strategy is even better! Wait…what?! You don’t have a disaster recovery strategy?! No good, my friend, no good… But don’t...
Last week I was pleased to attend Code Sprint 2016 in Paris, organised by the OSGeo Foundation: it has been an opportunity for many GIS users from all over the...
Version 1.6.0 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman is now able to receive WAL files via streaming replication protocol, as an additional channel (...
