Mon, 29 Apr 2024 16:04:06 +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/transparent-data-encryption-tde/ https://www.percona.com/blog/transparent-data-encryption-tde/#respond Fri, 02 Feb 2024 13:00:23 +0000 https://www.percona.com/blog/?p=84323 This blog was originally published in December of 2022 and updated in February of 2024.Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. This is often done to protect sensitive data from unauthorized access or theft. With transparent data […]]]> https://www.percona.com/blog/transparent-data-encryption-tde/feed/ 0 84323 https://www.percona.com/blog/postgresql-database-security-what-you-need-to-know/ https://www.percona.com/blog/postgresql-database-security-what-you-need-to-know/#comments Tue, 02 Jan 2024 12:00:58 +0000 https://www.percona.com/blog/?p=73259 This blog was published in January of 2021 and was updated in January of 2024.Database security, particularly in the context of PostgreSQL, involves safeguarding multiple parts of the database ecosystem. It is a vast topic because, with databases, we need to secure everything, not just the database node. The diagram below illustrates the key components […]]]> https://www.percona.com/blog/postgresql-database-security-what-you-need-to-know/feed/ 1 73259 https://www.percona.com/blog/postgresql-vacuuming-to-optimize-database-performance-and-reclaim-space/ https://www.percona.com/blog/postgresql-vacuuming-to-optimize-database-performance-and-reclaim-space/#comments Thu, 01 Jun 2023 13:00:14 +0000 https://www.percona.com/blog/?p=84429 This blog post was originally published in January 2023 and was updated in June 2023.In PostgreSQL, the vacuum command is a maintenance task that helps to optimize database performance and reclaim disk space. Using the PostgreSQL vacuum command involves removing deleted or outdated rows from tables and indexes and updating statistics used by the query […]]]> https://www.percona.com/blog/postgresql-vacuuming-to-optimize-database-performance-and-reclaim-space/feed/ 1 84429 https://www.percona.com/blog/tuning-postgresql-database-parameters-to-optimize-performance/ https://www.percona.com/blog/tuning-postgresql-database-parameters-to-optimize-performance/#comments Mon, 01 May 2023 11:00:27 +0000 https://www.percona.com/blog/?p=51472 This blog was originally published in August 2018 and was updated in May 2023.Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Default values are set to ensure that PostgreSQL runs everywhere, with the least resources it can consume, and so that it doesn’t cause any vulnerabilities. It has […]]]> https://www.percona.com/blog/tuning-postgresql-database-parameters-to-optimize-performance/feed/ 4 51472 https://www.percona.com/blog/postgresql-database-security-external-server-based-authentication/ https://www.percona.com/blog/postgresql-database-security-external-server-based-authentication/#respond Thu, 02 Feb 2023 14:06:12 +0000 https://www.percona.com/blog/?p=84881 Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. The authentication process is typically accomplished through usernames and passwords and includes other factors such as security tokens and one-time passwords. Database Administrators (DBAs) […]]]> https://www.percona.com/blog/postgresql-database-security-external-server-based-authentication/feed/ 0 84881 https://www.percona.com/blog/unlocking-the-secrets-of-toast-how-to-optimize-large-column-storage-in-postgresql-for-top-performance-and-scalability/ https://www.percona.com/blog/unlocking-the-secrets-of-toast-how-to-optimize-large-column-storage-in-postgresql-for-top-performance-and-scalability/#comments Wed, 01 Feb 2023 13:03:51 +0000 https://www.percona.com/blog/?p=84716 PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This post will look at using The Oversized-Attribute Storage Technique (TOAST) to improve performance and scalability. PostgreSQL uses fixed-sized pages, which makes it challenging to store huge data values […]]]> https://www.percona.com/blog/unlocking-the-secrets-of-toast-how-to-optimize-large-column-storage-in-postgresql-for-top-performance-and-scalability/feed/ 3 84716 https://www.percona.com/blog/upgrading-postgresql-extensions/ https://www.percona.com/blog/upgrading-postgresql-extensions/#comments Wed, 11 Jan 2023 13:12:33 +0000 https://www.percona.com/blog/?p=84433 PostgreSQL is a powerful and flexible open-source database management system that allows users to install and use extensions to add additional functionality to their databases. In this tutorial, we will cover the process of installing and upgrading PostgreSQL extensions using the example of the pg_stat_monitor extension.The pg_stat_monitor is a PostgreSQL extension that provides real-time monitoring […]]]> https://www.percona.com/blog/upgrading-postgresql-extensions/feed/ 1 84433 https://www.percona.com/blog/postgresql-14-database-monitoring-and-logging-enhancements/ https://www.percona.com/blog/postgresql-14-database-monitoring-and-logging-enhancements/#respond Mon, 29 Nov 2021 14:29:20 +0000 https://www.percona.com/blog/?p=79040 PostgreSQL-14 was released in September 2021, and it contained many performance improvements and feature enhancements, including some features from a monitoring perspective. As we know, monitoring is the key element of any database management system, and PostgreSQL keeps updating and enhancing the monitoring capabilities. Here are some key ones in PostgreSQL-14.Query IdentifierQuery identifier is used […]]]> https://www.percona.com/blog/postgresql-14-database-monitoring-and-logging-enhancements/feed/ 0 79040 https://www.percona.com/blog/postgresql-database-security-os-authentication/ https://www.percona.com/blog/postgresql-database-security-os-authentication/#respond Mon, 23 Aug 2021 13:28:41 +0000 https://www.percona.com/blog/?p=77706 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 authentication; a user can only do what they are authorized to do (authorization) and log […]]]> https://www.percona.com/blog/postgresql-database-security-os-authentication/feed/ 0 77706 https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/ https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/#respond Fri, 30 Jul 2021 13:50:25 +0000 https://www.percona.com/blog/?p=77509 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 detailed statistics through a number of catalog views and extensions that can be easily added to provide more detailed […]]]> https://www.percona.com/blog/improve-postgresql-query-performance-insights-with-pg_stat_monitor/feed/ 0 77509 https://www.percona.com/blog/postgres_fdw-enhancement-in-postgresql-14/ https://www.percona.com/blog/postgres_fdw-enhancement-in-postgresql-14/#comments Wed, 02 Jun 2021 19:10:35 +0000 https://www.percona.com/blog/?p=76265 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 look under the hood and find out what has changed from version 13, see what has […]]]> https://www.percona.com/blog/postgres_fdw-enhancement-in-postgresql-14/feed/ 2 76265 https://www.percona.com/blog/new-features-in-postgresql-14-bulk-inserts-for-foreign-data-wrappers/ https://www.percona.com/blog/new-features-in-postgresql-14-bulk-inserts-for-foreign-data-wrappers/#respond Thu, 27 May 2021 19:02:42 +0000 https://www.percona.com/blog/?p=76246 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. The feature set of foreign data wrapper is expanding since version 9.1. We know that the […]]]> https://www.percona.com/blog/new-features-in-postgresql-14-bulk-inserts-for-foreign-data-wrappers/feed/ 0 76246 https://www.percona.com/blog/postgresql-database-security-authentication/ https://www.percona.com/blog/postgresql-database-security-authentication/#comments Mon, 01 Feb 2021 18:46:46 +0000 https://www.percona.com/blog/?p=73255 Recently, I wrote an overview about what you need to know about PostgreSQL security. For this post, I want to write about PostgreSQL authentication. It is divided into three categories: 1. PostgreSQL Internal Authentication, 2. OS-based Authentication, and 3. External Server-Based Authentication.  In most cases, PostgreSQL is configured to be used with internal authentication, so […]]]> https://www.percona.com/blog/postgresql-database-security-authentication/feed/ 2 73255 https://www.percona.com/blog/how-to-create-postgresql-custom-builds-and-debian-packages/ Thu, 28 Jan 2021 19:16:59 +0000 https://www.percona.com/blog/?p=74087 Some time ago, I required a specific version of PostgreSQL. After searching on all the repositories, I was unable to find that specific version. It seems that the PostgreSQL community removes the old package when a new minor version comes. For example, if you need the 12.2 version but the 12.3 version is out, it’s […]]]> 74087 https://www.percona.com/blog/postgresql-13-new-feature-dropdb-force/ Thu, 01 Oct 2020 15:58:38 +0000 https://www.percona.com/blog/?p=71559 There have been many big features added to PostgreSQL 13, like Parallel Vacuum, de-duplication of indexes, etc., and a complete list can be found at PostgreSQL 13 release notes. Along with the big features, there are also small ones added, including dropdb –force.Dropdb –forceA new command-line option is added to dropdb command, and a similar […]]]> 71559 https://www.percona.com/blog/postgresql_fdw-authentication-changes-in-postgresql-13/ https://www.percona.com/blog/postgresql_fdw-authentication-changes-in-postgresql-13/#comments Wed, 30 Sep 2020 18:30:32 +0000 https://www.percona.com/blog/?p=71546 PostgreSQL 13 is released with some cool features, such as index enhancement, partition enhancements, and many others. Along with these enhancements, there are some security-related enhancements that require some explanation. There are two major ones: one is related to libpq and the other is related to postgres_fdw. As it is known that postgres_fdw  is considered […]]]> https://www.percona.com/blog/postgresql_fdw-authentication-changes-in-postgresql-13/feed/ 4 71546 https://www.percona.com/blog/index-improvements-in-postgresql-13/ Thu, 10 Sep 2020 17:39:17 +0000 https://www.percona.com/blog/?p=71077 Indexes are one of the core features of all the database management systems (DBMS). Indexes have a very long history in PostgreSQL, which has quite a rich set of index features. PostgreSQL has B-Tree, Hash,  GIN, GIST, and BRIN indexes. And because the development around indexes is still going on, PostgreSQL 13 provides some enhancements.We […]]]> 71077 https://www.percona.com/blog/migrating-to-postgresql-version-13-incompatibilities-you-should-be-aware-of/ Tue, 28 Jul 2020 18:26:19 +0000 https://www.percona.com/blog/?p=69947 The PostgreSQL 13 Beta is out in the testing phase with a rich feature set. It is a very good learning effort to participate in the testing of one of the finest databases in the world. It does not matter how much development, coding, and administration experience you have for the testing of the PostgreSQL […]]]> 69947 https://www.percona.com/blog/multi-master-replication-solutions-for-postgresql/ https://www.percona.com/blog/multi-master-replication-solutions-for-postgresql/#comments Tue, 09 Jun 2020 17:28:41 +0000 https://www.percona.com/blog/?p=68048 Due to the immense generation of data, scalability has become one of the hottest topics in the field of databases. Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the capability of the database to store and process more data, for example, adding a new process, […]]]> https://www.percona.com/blog/multi-master-replication-solutions-for-postgresql/feed/ 2 68048 https://www.percona.com/blog/10-common-postgresql-errors/ https://www.percona.com/blog/10-common-postgresql-errors/#comments Fri, 05 Jun 2020 14:27:04 +0000 https://www.percona.com/blog/?p=68742 Sometimes PostgreSQL users get errors and warnings and they are unable to understand why. To cater to these situations, this blog will cover some common errors and warnings in PostgreSQL. In some cases, it is a user setting problem or query error, but in other cases, it can be a PostgreSQL bug. But, it is […]]]> https://www.percona.com/blog/10-common-postgresql-errors/feed/ 2 68742