Wed, 20 Mar 2024 13:51: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/leverage-index-only-scans-in-postgresql/ https://www.percona.com/blog/leverage-index-only-scans-in-postgresql/#respond Wed, 20 Mar 2024 13:51:31 +0000 https://www.percona.com/blog/?p=95111 In a previous blog, One Index, Three Different PostgreSQL Scan Types: Bitmap, Index, and Index Only, we reviewed three ways PostgreSQL can use an index to retrieve data as quickly as possible. In the same blog, we saw the fastest and most efficient method is the Index-Only Scan because this saves time by avoiding the […]]]> https://www.percona.com/blog/leverage-index-only-scans-in-postgresql/feed/ 0 95111 https://www.percona.com/blog/one-index-three-different-postgresql-scan-types-bitmap-index-and-index-only/ https://www.percona.com/blog/one-index-three-different-postgresql-scan-types-bitmap-index-and-index-only/#respond Thu, 06 Jul 2023 13:42:11 +0000 https://www.percona.com/blog/?p=89267 Performance is one of the essential aspects of a database management system. Very little can be more annoying and frustrating for users than poor performance, meaning long-running queries and high response times at the front end. One of the most effective ways to tackle performance improvement is having the proper indexes for the table columns. An […]]]> https://www.percona.com/blog/one-index-three-different-postgresql-scan-types-bitmap-index-and-index-only/feed/ 0 89267 https://www.percona.com/blog/missing-library-a-pg_upgrade-history/ https://www.percona.com/blog/missing-library-a-pg_upgrade-history/#comments Thu, 29 Dec 2022 14:21:26 +0000 https://www.percona.com/blog/?p=84364 While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade.The last is a good option when you can afford some downtime and desire […]]]> https://www.percona.com/blog/missing-library-a-pg_upgrade-history/feed/ 1 84364 https://www.percona.com/blog/introducing-performance-improvement-of-window-functions-in-postgresql-15/ https://www.percona.com/blog/introducing-performance-improvement-of-window-functions-in-postgresql-15/#respond Thu, 04 Aug 2022 12:00:41 +0000 https://www.percona.com/blog/?p=82030 When working with databases, there are always some projects oriented to performing analytics and reporting tasks over the information stored in the database. Usually, these tasks leverage window functions to do calculations “across a set of table rows that are somehow related to the current row,” as is described in the documentation.There are several built-in […]]]> https://www.percona.com/blog/introducing-performance-improvement-of-window-functions-in-postgresql-15/feed/ 0 82030 https://www.percona.com/blog/parallel-commits-for-transactions-using-postgres_fdw-on-postgresql-15/ https://www.percona.com/blog/parallel-commits-for-transactions-using-postgres_fdw-on-postgresql-15/#respond Thu, 14 Jul 2022 14:00:45 +0000 https://www.percona.com/blog/?p=81749 Consuming data from a remote foreign database into our local database just like another local table is a great feature that adds an excellent level of flexibility to the design of a database solution. This option is present in a number of database products. Oracle (DBLINK), MySQL (FEDERATED Engine), and obviously, PostgreSQL (dblink, postgres_fdw) support it. […]]]> https://www.percona.com/blog/parallel-commits-for-transactions-using-postgres_fdw-on-postgresql-15/feed/ 0 81749 https://www.percona.com/blog/postgresql-14-predefined-roles-making-access-control-easy/ https://www.percona.com/blog/postgresql-14-predefined-roles-making-access-control-easy/#respond Tue, 08 Feb 2022 14:49:50 +0000 https://www.percona.com/blog/?p=80013 The PostgreSQL RDBMS has shown rapid growth in terms of adoption and usability for a wide range of industries and projects. The same is true as for the new methodologies for application development and deployment, which currently focuses on making it easier for developers to get the infrastructure and the DB model they need with […]]]> https://www.percona.com/blog/postgresql-14-predefined-roles-making-access-control-easy/feed/ 0 80013 https://www.percona.com/blog/postgresql-logical-replication-using-an-rds-snapshot/ https://www.percona.com/blog/postgresql-logical-replication-using-an-rds-snapshot/#comments Mon, 26 Jul 2021 13:35:27 +0000 https://www.percona.com/blog/?p=75310 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 set of tables or even only some columns/rows, also […]]]> https://www.percona.com/blog/postgresql-logical-replication-using-an-rds-snapshot/feed/ 11 75310