Last week, 2ndQuadrant‘s Gabriele Bartolini was privileged to speak at IBM Italia’s Open Innovation event in Milan, Italy. At this event, IBM highlighted the strengths of open source such as flexibility, continuous innovation, and a collaborative community. With the impact of open source growing rapidly on business decisions, members of the open source and PostgreSQL […]
PostgreSQL vs. Linux kernel versions
/14 Comments/in 2ndQuadrant, Featured, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraI’ve published multiple benchmarks comparing different PostgreSQL versions, as for example the performance archaeology talk (evaluating PostgreSQL 7.4 up to 9.4), and all those benchmark assumed fixed environment (hardware, kernel, …). Which is fine in many cases (e.g. when evaluating performance impact of a patch), but on production those things do change over time – […]
PostgreSQL Solutions Roadmap
/0 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsIn a recent blog, I described features for PostgreSQL Core that we’ve been working on https://www.2ndquadrant.com/en/blog/postgresql-solutions-roadmap/ Many people have asked for a similar roadmap for BDR and Postgres-XL. I can confirm that both are under active development and in active use. Postgres-XL (link) XL 9.5 v1.2 is now available, with more updates coming. XL 9.6 […]
Thoughts on Uber’s List of Postgres Limitations
/11 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsAn Uber technical blog of July 2016 described the perception of “many Postgres limitations”. Regrettably, a number of important technical points are either not correct or not wholly correct because they overlook many optimizations in PostgreSQL that were added specifically to address the cases discussed. In most cases, those limitations were actually true in the […]
PostgreSQL 10 Roadmap
/10 Comments/in 2ndQuadrant, Simon's PlanetPostgreSQL /by Simon RiggsAt the PostgreSQL developer meeting we discussed putting up everybody’s roadmap projects in one place: http://wiki.postgresql.org/wiki/PostgreSQL10_Roadmap.
Improvements in repmgr 3.1.4
/0 Comments/in Ian's PlanetPostgreSQL /by Ian BarwickThe recently released repmgr 3.1.4 update incorporates several changes which improve usability and lay out the groundwork for enhanced compatibility with 2ndQuadrant’s barman product. New configuration option restore_command It’s now possible to specify a restore_command in repmgr.conf, which will be included in the recovery.conf file generated by repmgr standby clone, making it easier to configure […]
Evolution of Fault Tolerance in PostgreSQL: Time Travel
/0 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 third post of the series and we’ll talk about timeline issues and their effects on fault tolerance and dependability of PostgreSQL. […]
Speed up getting WAL files from Barman
/0 Comments/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele BartoliniStarting from Barman 1.6.1, PostgreSQL standby servers can rely on an “infinite” basin of WAL files and finally pre-fetch batches of WAL files in parallel from Barman, speeding up the restoration process as well as making the disaster recovery solution more resilient as a whole. The master, the backup and the standby Before we start, […]
Report from DatabaseCamp, NYC
/0 Comments/in Featured, Simon's PlanetPostgreSQL /by Simon RiggsJust got back from extended trip to Database.Camp – Sunday, July 10, 2016 – at the UN in NYC – Totally Free! Wide range of presentations from CTOs/CEOs from across the database software world, with about 200 attendees, slightly more people earlier in the day. Very happy to report we had 3 presentations covering different […]
Working Together to create an Open Source World
/0 Comments/in 2ndQuadrant /by Britt ColeLast week, 2ndQuadrant‘s Gabriele Bartolini was privileged to speak at IBM Italia’s Open Innovation event in Milan, Italy. At this event, IBM highlighted the strengths of open source such as flexibility, continuous innovation, and a collaborative community. With the impact of open source growing rapidly on business decisions, members of the open source and PostgreSQL […]
How to check the lock level taken by operations in PostgreSQL
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPostgreSQL’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.