by David Gonzalez | Mar 20, 2024 | Insight for DBAs, PostgreSQL
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... by David Gonzalez | Jul 6, 2023 | Insight for DBAs, PostgreSQL
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... by David Gonzalez | Dec 29, 2022 | Insight for DBAs, PostgreSQL
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... by David Gonzalez | Aug 4, 2022 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
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... by David Gonzalez | Jul 14, 2022 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
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.... by David Gonzalez | Feb 8, 2022 | Insight for DBAs, Insight for Developers, PostgreSQL
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... 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...