How to Get the Best Out of PostgreSQL Logs
Learn how to effectively configure PostgreSQL log management for troubleshooting performance problems.
Posts
Keep your libraries updated and nobody gets hurt
/0 Comments/in Jimmy's Planet PostgreSQL /by Jimmy AngelakosDon’t make people practice software archaeology – keep your system updated. Updates? One of the benefits of the open-source world is the unmatched ability to issue updates rapidly to correct bugs and security vulnerabilities. Software bug fixes keep streaming in: from recently introduced regressions, to long-standing bugs undetected for years, they are corrected by a […]
PostgreSQL: Regular expressions and pattern matching
/1 Comment/in Haroon's PlanetPostgreSQL /by Muhammad HaroonA regular expression is a special text string used to describe a search pattern. PostgreSQL’s regular expressions supports three separate approaches to pattern matching: POSIX-style regular expressions (BREs and EREs) SIMILAR TO operator added in SQL:1999 SQL LIKE operator There are some more advanced techniques for advanced pattern matching requirements but those will very likely […]
PostgreSQL Meltdown
/0 Comments/in Simon's PlanetPostgreSQL /by Simon RiggsSpectre and Meltdown have caused severe alarm in recent days. You may have read about up to 30% impact on PostgreSQL databases, which I believe to be overstated because of misunderstandings in the media. Let’s dig into this in more detail. TL;DR Summary: no PostgreSQL patch required, -7% performance hit In response to these new […]
PostgreSQL Popularity Continues to Grow!
/1 Comment/in Simon's PlanetPostgreSQL /by Simon RiggsSome years ago, I prophesized that PostgreSQL would win in the end, and that we would be able to tell because there would be “Microsoft PostgreSQL”. I am happy to report that has now happened. Microsoft PostgreSQL database service on Azure was announced recently. Of course, that was just a metaphor for “a.n.other big company”, […]
Barman 2.1 and the new –archive option
/0 Comments/in Giulio's PlanetPostgreSQL /by Giulio CalacociBarman 2.1 Version 2.1 of Barman, backup and recovery manager for PostgreSQL, was released Thursday, Jan. 5. The new release, along with several bugfixes, introduces preliminary support for the upcoming PostgreSQL 10, and adds the –archive option to the switch-xlog command. switch-xlog –archive The new –archive option is especially useful when setting up a new […]
PGDay.IT 2016 in Prato, Italy
/0 Comments/in 2ndQuadrant, Jonathan's PlanetPostgreSQL /by Jonathan BattiatoThis year, the ITPUG (Italian Postgres User Group) organized PGDay in Prato, my hometown and city where the association was born, although most of the members are from outside of the Tuscany region. It was my pleasure to contribute to the community by sharing my professional experience. I gave a talk about PostgreSQL on Network File System, […]
The PostgreSQL License – What Does It Mean For My Business?
/5 Comments/in Umair's PlanetPostgreSQL /by Umair ShahidWhen I talk to various people about PostgreSQL, based on where they are in the process of analyzing it, I get asked many similar questions. One of the most frequently asked questions is: What is the PostgreSQL licensing model? Here is my attempt to address this question from the perspective of what the PostgreSQL license […]
Untangling the PostgreSQL upgrade
/8 Comments/in pglogical, PostgreSQL /by Martín MarquésPostgreSQL 9.6 has just been released and most of the postgres users will start asking themselves how to upgrade to the new major version. This post has the intention of showing different procedures for upgrading your PostgreSQL server. Upgrading to a new major version is a task which has a high ratio of preparation over […]
Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit
/2 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin YildirimPostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. This is the fourth post of the series and we’ll talk about synchronous commit and its effects on fault tolerance and dependability of PostgreSQL. […]
