Wed, 08 May 2024 18:11:31 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/ https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/#respond Wed, 08 May 2024 18:11:31 +0000 https://www.percona.com/blog/?p=96112 Coroot, an open source observability tool powered by eBPF, went generally available with version 1.0 last week. As this tool is cloud-native, we were curious to know how it can help troubleshoot databases on Kubernetes.In this blog post, we will see how to quickly debug PostgreSQL with Coroot and Percona Operator for PostgreSQL.PrepareInstall CorootThe easiest […]]]> https://www.percona.com/blog/troubleshooting-postgresql-on-kubernetes-with-coroot/feed/ 0 96112 https://www.percona.com/blog/speed-up-repetitive-postgresql-statements-with-gexec/ https://www.percona.com/blog/speed-up-repetitive-postgresql-statements-with-gexec/#respond Tue, 07 May 2024 16:15:05 +0000 https://www.percona.com/blog/?p=96166 Last week, we were assisting a client who needed to resolve an issue related to partitioned tables.Often, a table can include dozens or even hundreds of partitions. Unfortunately, some object-level parameters for tuning (like storage_parameter) cannot be modified from the parent table and must be manipulated directly through the child table. As a result, we […]]]> https://www.percona.com/blog/speed-up-repetitive-postgresql-statements-with-gexec/feed/ 0 96166 https://www.percona.com/blog/ldap-authentication-in-pgbouncer-through-pam/ https://www.percona.com/blog/ldap-authentication-in-pgbouncer-through-pam/#respond Tue, 30 Apr 2024 14:46:30 +0000 https://www.percona.com/blog/?p=96054 There are many cases where external connection poolers like pgBouncer become unavoidable despite the costs and complexities associated with them. PgBouncer is one of the most popular external connection poolers for PostgreSQL. It is thin and lightweight, so it doesn’t have built-in authentication features like LDAP, which is essential for many enterprises. Luckily, pgBouncer has […]]]> https://www.percona.com/blog/ldap-authentication-in-pgbouncer-through-pam/feed/ 0 96054 https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/ https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/#respond Fri, 26 Apr 2024 15:54:53 +0000 https://www.percona.com/blog/?p=96020 The tech preview version of the pg_tde extension for PostgreSQL 16 was released on March 28th, with many improvements compared to our previous MVP release. In addition to lots of bug fixes, the new release supports multi-tenancy and key rotation with a simplified configuration mechanism. Note that the Tech Preview release is not recommended for […]]]> https://www.percona.com/blog/trying-out-the-postgresql-pg_tde-tech-preview-release/feed/ 0 96020 https://www.percona.com/blog/postgresql-database-security-best-practices/ https://www.percona.com/blog/postgresql-database-security-best-practices/#respond Mon, 22 Apr 2024 13:59:22 +0000 https://www.percona.com/blog/?p=95970 When data is everything, the sophistication of cybersecurity threats casts a shadow over the world of data security, including for those using PostgreSQL as their database of choice. Although renowned for its reliability, flexibility, and strong feature set, in the face of relentless cyber-attacks, even users of PostgreSQL can find themselves in a situation where […]]]> https://www.percona.com/blog/postgresql-database-security-best-practices/feed/ 0 95970 https://www.percona.com/blog/ultimate-guide-to-improving-database-performance/ https://www.percona.com/blog/ultimate-guide-to-improving-database-performance/#respond Thu, 18 Apr 2024 13:25:39 +0000 https://www.percona.com/blog/?p=95915 Welcome to the ultimate guide on how to boost your database performance! We’ve designed it to help you understand and improve the performance of your databases, regardless of your level of experience as a DBA or whether you manage databases for a small or large company.We’ll cover a number of very important topics, such as […]]]> https://www.percona.com/blog/ultimate-guide-to-improving-database-performance/feed/ 0 95915 https://www.percona.com/blog/switch-postgresql-environments-across-aws-gcp-and-k3d-using-kubernetes-contexts/ https://www.percona.com/blog/switch-postgresql-environments-across-aws-gcp-and-k3d-using-kubernetes-contexts/#respond Wed, 17 Apr 2024 13:25:31 +0000 https://www.percona.com/blog/?p=95872 This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how to set up this distribution on Kubernetes clusters in AWS, Google Cloud, and locally with k3d. You’ll also learn how to switch between these setups to test them effectively.In Kubernetes, a context is a profile […]]]> https://www.percona.com/blog/switch-postgresql-environments-across-aws-gcp-and-k3d-using-kubernetes-contexts/feed/ 0 95872 https://www.percona.com/blog/partially-rolling-back-a-transaction-in-mysql-or-postgresql/ https://www.percona.com/blog/partially-rolling-back-a-transaction-in-mysql-or-postgresql/#respond Fri, 12 Apr 2024 13:36:18 +0000 https://www.percona.com/blog/?p=95737 This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this feature in databases.DescriptionEvery ACID-compliant RDBMS follows the “All or None” […]]]> https://www.percona.com/blog/partially-rolling-back-a-transaction-in-mysql-or-postgresql/feed/ 0 95737 https://www.percona.com/blog/json_table-will-be-in-postgresql-17/ https://www.percona.com/blog/json_table-will-be-in-postgresql-17/#respond Thu, 11 Apr 2024 15:11:37 +0000 https://www.percona.com/blog/?p=95673 JSON_TABLE() will be in PostgreSQL 17! It almost made it two years ago but was yanked away at the last minute. We will get it shortly when PostgreSQL 17 is officially released this year! Please see this.Why is this important?JSON has become the data interchange format of choice for most developers. JSON had a litany […]]]> https://www.percona.com/blog/json_table-will-be-in-postgresql-17/feed/ 0 95673 https://www.percona.com/blog/protect-your-postgresql-database-with-pg_tde-safe-and-secure/ https://www.percona.com/blog/protect-your-postgresql-database-with-pg_tde-safe-and-secure/#respond Tue, 09 Apr 2024 12:41:11 +0000 https://www.percona.com/blog/?p=95493 Tech Preview release of pg_tde now availableAs organizations collect, store, and analyze vast amounts of data, ensuring its confidentiality and integrity becomes a top priority. For PostgreSQL users, the tech preview release availability of the new encryption extension pg_tde delivers unmatched protection for vital data assets.What is pg_tde?pg_tde, developed by Percona, is an open source […]]]> https://www.percona.com/blog/protect-your-postgresql-database-with-pg_tde-safe-and-secure/feed/ 0 95493 https://www.percona.com/blog/best-practices-for-postgresql-migration/ https://www.percona.com/blog/best-practices-for-postgresql-migration/#respond Fri, 05 Apr 2024 13:09:06 +0000 https://www.percona.com/blog/?p=95675 PostgreSQL’s reputation as a powerful, open source database management system has been steadily rising, making it a top choice for businesses looking to upgrade or switch their database infrastructure. Thanks to its comprehensive SQL compliance, scalability, performance, and cost efficiency, it stands out as a preferred option among developers and database administrators. It is so […]]]> https://www.percona.com/blog/best-practices-for-postgresql-migration/feed/ 0 95675 https://www.percona.com/blog/foreign-data-wrappers-in-postgresql-databases-postgres_fdw-dblink/ https://www.percona.com/blog/foreign-data-wrappers-in-postgresql-databases-postgres_fdw-dblink/#respond Wed, 03 Apr 2024 16:35:39 +0000 https://www.percona.com/blog/?p=95497 A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source and access data without physically moving the data on a working local database.PostgreSQL implements portions of the SQL/MED specification, allowing access to data that resides outside PostgreSQL using regular SQL queries. Such data, which is […]]]> https://www.percona.com/blog/foreign-data-wrappers-in-postgresql-databases-postgres_fdw-dblink/feed/ 0 95497 https://www.percona.com/blog/postgresql-for-mysql-dbas-second-edition-is-now-available/ https://www.percona.com/blog/postgresql-for-mysql-dbas-second-edition-is-now-available/#respond Tue, 02 Apr 2024 17:24:16 +0000 https://www.percona.com/blog/?p=95539 Many years ago, when I was the Certification Manager for MySQL AB, I would be in contact with hiring managers looking for talent. One frustrated individual informed me that while it was hard to find a qualified MySQL DBA, it was impossible to find a qualified PostgreSQL DBA. Years later, that same sentiment is still […]]]> https://www.percona.com/blog/postgresql-for-mysql-dbas-second-edition-is-now-available/feed/ 0 95539 https://www.percona.com/blog/five-reasons-why-wal-segments-accumulate-in-the-pg_wal-directory-in-postgresql/ https://www.percona.com/blog/five-reasons-why-wal-segments-accumulate-in-the-pg_wal-directory-in-postgresql/#respond Tue, 02 Apr 2024 13:48:56 +0000 https://www.percona.com/blog/?p=95470 One of the most frequent concerns we see in the Percona support team is: Why is my pg_wal growing? / pg_wal is filling up the filesystem / pg_wal does not release the space, and so on.In PostgreSQL, the pg_wal directory plays a crucial role in managing the Write-Ahead Logging (WAL) mechanism, which ensures the durability […]]]> https://www.percona.com/blog/five-reasons-why-wal-segments-accumulate-in-the-pg_wal-directory-in-postgresql/feed/ 0 95470 https://www.percona.com/blog/percona-pg_tde-project-keyring-options/ https://www.percona.com/blog/percona-pg_tde-project-keyring-options/#respond Mon, 01 Apr 2024 13:17:52 +0000 https://www.percona.com/blog/?p=95492 Percona’s pg_tde project brings a long-needed ability to encrypt data to PostgreSQL transparently. We are actively asking you to test this code to help build a better project. So please test pg_tde!As you have probably read in earlier blogs on pg_tde, it depends on a keyring.Two keysEncrypting the data requires two types of keys.The first […]]]> https://www.percona.com/blog/percona-pg_tde-project-keyring-options/feed/ 0 95492 https://www.percona.com/blog/postgresql-indexes-can-hurt-you-negative-effects-and-the-costs-involved/ https://www.percona.com/blog/postgresql-indexes-can-hurt-you-negative-effects-and-the-costs-involved/#respond Mon, 01 Apr 2024 11:15:43 +0000 https://www.percona.com/blog/?p=87199 This blog was originally published in April 2023 and was updated in April 2024.Indexes are generally considered to be the panacea when it comes to SQL performance tuning, and PostgreSQL supports different types of indexes catering to different use cases. I keep seeing many articles and talks on “tuning” discussing how creating new indexes speeds […]]]> https://www.percona.com/blog/postgresql-indexes-can-hurt-you-negative-effects-and-the-costs-involved/feed/ 0 87199 https://www.percona.com/blog/postgresql-partitioning-using-traditional-methods/ https://www.percona.com/blog/postgresql-partitioning-using-traditional-methods/#respond Mon, 01 Apr 2024 11:00:45 +0000 https://www.percona.com/blog/?p=89092 This blog was originally published in July 2023 and was updated in April 2024.Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. In this article, we’ll discuss how to effectively use traditional partitioning methods in PostgreSQL to effectively split tables and improve database performance. Methods of […]]]> https://www.percona.com/blog/postgresql-partitioning-using-traditional-methods/feed/ 0 89092 https://www.percona.com/blog/postgresql-pgpool-ii-use-cases-and-benefits/ https://www.percona.com/blog/postgresql-pgpool-ii-use-cases-and-benefits/#respond Mon, 01 Apr 2024 09:00:09 +0000 https://www.percona.com/blog/?p=86687 This blog was published in April of 2023 and updated in April 2024.PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. One of the key benefits of using PostgreSQL is its reliability, scalability, and performance. However, as the size of your database grows, it can […]]]> https://www.percona.com/blog/postgresql-pgpool-ii-use-cases-and-benefits/feed/ 0 86687 https://www.percona.com/blog/importance-of-postgresql-vacuum-tuning-and-custom-scheduled-vacuum-job/ https://www.percona.com/blog/importance-of-postgresql-vacuum-tuning-and-custom-scheduled-vacuum-job/#respond Mon, 01 Apr 2024 08:00:16 +0000 https://www.percona.com/blog/?p=81237 This blog was originally published in June 2022 and was updated in April 2024.PostgreSQL’s built-in autovacuum – the housekeeper – is improving, version after version. It is becoming more capable while reducing its overhead and addressing edge cases. I think there is no PostgreSQL version that comes out without any autovacuum improvement, and no doubt […]]]> https://www.percona.com/blog/importance-of-postgresql-vacuum-tuning-and-custom-scheduled-vacuum-job/feed/ 0 81237 https://www.percona.com/blog/percona-postgresql-pg_tde-extension-march-update/ https://www.percona.com/blog/percona-postgresql-pg_tde-extension-march-update/#respond Thu, 28 Mar 2024 14:41:58 +0000 https://www.percona.com/blog/?p=95442 Transparent Data Encryption is one ‘missing item’ in comparing PostgreSQL to commercial databases. Percona’s pg_tde project will correct this shortcoming. Progress is ongoing, and Percona would love your feedback, so please download and test.DocumentationThe pg_tde documentation is here. You will find many options for obtaining pg_tde – Docker images, RPM, DEB, and source code.What pg_tde […]]]> https://www.percona.com/blog/percona-postgresql-pg_tde-extension-march-update/feed/ 0 95442