by Daniil Bazhenov | Oct 1, 2021 | MongoDB, MySQL, Percona Events, PostgreSQL
Percona serves several communities including MySQL, PostgreSQL, and MongoDB. The Percona Community Team is committed to promoting content and technical advice on open source database technologies and needs. Hence, we organize monthly MeetUps as a series of regular...
by Umair Shahid | Sep 30, 2021 | Database Trends, Percona Software, PostgreSQL
Today saw the launch of PostgreSQL14. For me, the important area to focus on is what the community has done to improve performance for heavy transactional workloads and additional support for distributed data. The amount of data that enterprises have to process...
by Umair Shahid | Sep 27, 2021 | Database Trends, Insight for DBAs, Percona Software, PostgreSQL
The future of technology adoption belongs to developers. The future of application deployment belongs in the cloud. The future of databases belongs to open source. That’s essentially the summary of Percona’s innovation strategy and that’s the reason I decided to join...
by Matt Yonkovit | Sep 8, 2021 | Insight for DBAs, PostgreSQL
by Matt Yonkovit | Sep 3, 2021 | Insight for DBAs, PostgreSQL
Continuing our series on storing JSON directly within your database, we are now looking at the JSON functionality built into PostgreSQL. You can see the first two posts in this series exploring MySQL’s JSON functionality with Storing JSON in Your Databases: Tips and...
by Sergey Kuzmichev | Aug 24, 2021 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
At the recent Percona Live, Agustín Gallego and I did a presentation “Optimizing and Troubleshooting PostgreSQL with PMM”. While preparing for this talk, I’ve ported some of the older PostgreSQL custom dashboards that we published over the years over at...
by Ibrar Ahmed | Aug 23, 2021 | Insight for DBAs, PostgreSQL, Security
Security is everybody’s concern when talking about data and information, and therefore it becomes the main foundation of every database. Security means protecting your data from unauthorized access. That means only authorized users can log in to a system called...
by Charly Batista | Aug 10, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
by Jobin Augustine | Aug 10, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
Many times, we see PostgreSQL users getting confused about the query/statement duration reported in PostgreSQL logs. Other PostgreSQL tools like pgBadger present the same data based on the log file, which further increases the confusion. Knowing the full impact of...
by Ibrar Ahmed | Jul 30, 2021 | Insight for DBAs, Monitoring, Percona Software, PostgreSQL
Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are obviously direct and indirect cost connotations as well. PostgreSQL provides very...
by Charly Batista | Jul 29, 2021 | Insight for DBAs, Insight for Developers, PostgreSQL
by David Gonzalez | Jul 26, 2021 | Cloud, Insight for DBAs, PostgreSQL
We have several PostgreSQL versions that support logical decoding to replicate data changes from a source database to a target database, which is a cool and very powerful tool that gives the option to replicate all the tables in a database, only one schema, a specific...
by Robert Bernier | Jul 19, 2021 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Good database maintenance includes not only performing the standard adding, updating, and deleting records, etc., but periodic edits to the table schema too. Operations such as adding, editing, and removing table columns are part of today’s life-cycle reality...
by Robert Bernier | Jun 28, 2021 | Insight for DBAs, Open Source, PostgreSQL, Security
PgBouncer is a great piece of technology! Over the years I’ve put it to good use in any number of situations requiring a particular type of control over application processes connecting to a postgres data cluster. However, sometimes it’s been a bit of a...
by Jobin Augustine | Jun 24, 2021 | Insight for DBAs, PostgreSQL
pg_repack is one of the oldest, widely used, extension projects for PostgreSQL. It is so much popular that even DBaaS service providers couldn’t avoid it. It is a “power tool” in the hands of a DBA to deal with bloated/fragmented tables. I...
by Dmitriy Kostiuk | Jun 23, 2021 | Cloud, MongoDB, MySQL, Percona Software, PostgreSQL
At some point, your needs for improving database performance may run into a threshold where optimization and tuning are no longer enough. If you cannot change the database engine and can no longer tune the parameters for your workload, you need to use scaling. As it...
by Fernando Laudares Camargos | Jun 11, 2021 | Insight for DBAs, Percona Live, Percona Software, PostgreSQL
A couple of weeks ago, Jobin and I did a short presentation during Percona Live Online bearing a similar title as the one for this post: “PostgreSQL HA With Patroni: Looking at Failure Scenarios and How the Cluster Recovers From Them”. We deployed a 3-node PostgreSQL...
by Ibrar Ahmed | Jun 2, 2021 | Insight for DBAs, PostgreSQL
Note: PostgreSQL 14 has been released. Please visit PostgreSQL 14 – Performance, Security, Usability, and Observability for additional information. It’s exciting times in the PostgreSQL world with the version 14 beta released a few days ago. It’s now time to...
by Ibrar Ahmed | May 27, 2021 | Insight for DBAs, PostgreSQL
On September 30, 2021, PostgreSQL 14 was released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability. Foreign Data Wrapper based on SQL-MED is one the coolest features of PostgreSQL....
by Sergey Pronin | May 26, 2021 | Cloud, Open Source, Percona Software, PostgreSQL
Percona is championing open source database software and we are committed to running our products on Kubernetes. We don’t only want to run the software, but make sure that the database is highly available, secure, and follows best practices. We also focus on day-2...
