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 of autovacuum tuning. I'll very briefly explain the necessary theory (dead tuples, bloat and how autovacuum deals with it), but the main focus of this blog post is tuning - what configuration options are there, rules of thumb, etc.
PostgreSQL 9.6 is now out and so is an updated version of pglogical that works with it.
For quick guide on how to upgrade the database with pglogical you can check my post which announced 9.6beta support.
The main change besides the support for 9.6.x release of PostgreSQL is in the way we handle the output plugin and apply plugin. They have now been merged into single code base and single package so that there is no need to track the pglogical_output separately for the users and developers alike.
We fixed several bugs this time and also made upgrades from 9.4 much easier.
Here is a more detailed list of changes:
keepalive is tuned to much smaller values by default so that pglogical will notice network issues earlier
better compatibility when upgrading from PostgreSQL 9.4 (more…)
The latest version of PostgreSQL 9.6 is planned to be released later today, bringing with it some much anticipated features and updates. As the most advanced open source database, PostgreSQL strives to release a major version roughly once every year. With an active and collaborative community, this PostgreSQL release boasts impressive features and updates thanks to contributions from many of the highly knowledgeable community members.
The expanding team at 2ndQuadrant has continued to show dedication to the PostgreSQL database project by contributing heavily to the PostgreSQL 9.6 release. Parallel execution of large queries has been a known shortcoming of PostgreSQL for some time, but this is no longer an issue with the 9.6 release. David Rowley and Simon Riggs contributed to (more…)
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 communities are working together to educate and empower the growth of this movement.
Gabriele not only shared the unique 2ndQuadrant experience of open source and PostgreSQL but gave an overview of the global community that is PostgreSQL.
Gabriele explained how a free and open license, combined with innovation and
progression are all positive aspects of migrating to PostgreSQL while still
maintaining business (more…)
After the earthquake that shook the city of L'Aquila and the entire
Abruzzo region, 2ndQuadrant Italia is pleased to announce the signing
of a collaborative agreement with the University of L'Aquila.