Virtual DevOps in a Day
Join us for this hands-on virtual workshop. Database DevOps in a Day will get you started on your Database DevOps journey and illustrate how Redgate’s tools can help to bridge the gap between development and operations.
Stay up to date with the latest PostgreSQL content, learn about upcoming events, join community discussions, and discover how Redgate tools can help solve your database challenges.
In Part I of this series, we explored overlap queries and the problems that accompany them, along with ways to improve their performance. We concluded by defining an overlap query in terms of timestamp ranges, which allowed us to use a new index type – known as GiST – that drastically sped up these types of queries. In Part II, we’ll boost overlap query performance even further, but first let’s cover some other features of range types. A Range For All Occasions Our Part I query used the following WHERE clause: The “tsrange()” functions return timestamp ranges. But overlap queries...… Read more
When you think of how to store data in a database, you think of data types. A data type represents a method of how some bit of data is stored internally. Whether it’s numbers, text, dates, or even more complex structures like JSON or geometric shapes, there is an internal format and a method to use that format when you use the data you stored. Along with columns, they are like the base building blocks for your database. MySQL and PostgreSQL offer numerous ways to store the type of data you collect. So, why are we comparing data types...… Read more
The temporal database is a database that can keep information on time when the facts represented in the database were, are, or will be valid. We briefly described major concepts of temporal databases and discussed types of queries that such databases can support in part 1 of this article(Saving Data Historically with Temporal Tables: Part 1: Queries) and discussed how aggregation can work in temporal databases in the part 2 (Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions). In both parts 1 and 2 we assumed that data are somehow stored in the temporal tables and concentrated...… Read more
The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after all, that’s what matters. Simply having a backup is fine. However, if you can’t restore your data from that backup, it doesn’t matter. On top of this is the ability to ensure you can restore your databases to a point in time, not simply to the last full backup. That ability requires a different approach to how you perform your backups. PostgreSQL has the capabilities to support backups as I already described in my first article on the topic. PostgreSQL...… Read more
This article explores PostgreSQL's buffer cache hit ratio (BCHR), a metric tracked by Redgate Monitor to help you assess the health and performance of your databases. By correctly interpreting this ratio and using it with other relevant memory and IO metrics, you can identify potential bottlenecks in query execution before they impact users. Read more
Current Activity for PostgreSQL in Redgate Monitor provides a real-time view of queries currently running on your PostgreSQL instances. It will allow you to identify quickly any queries that are currently causing blocking and resource contention issues on an instance. Read more
Any reliable DevOps deployment process must not only deliver the right database code but also ensure that the correct conditions exist for the deployment to succeed. For PostgreSQL databases, this includes ensuring that any extensions on which the database code relies are installed, and at the correct version. Fortunately, Flyway will automatically track which extensions are installed on a database and at what version, so we can 'propagate' these changes accurately during deployments and avoid inconsistencies in database behavior and even application breakages. Read more
Join us for this hands-on virtual workshop. Database DevOps in a Day will get you started on your Database DevOps journey and illustrate how Redgate’s tools can help to bridge the gap between development and operations.
In person. In Seattle November 17-21, 2025 Save the date: add to calendar Sign up here to be kept up to date!
The features available within SQL Server and PostgreSQL for functions and procedures are different in some surprising ways. Join Grant Fritchey and Ryan Booz in this on-demand webinar as they uncover the secrets behind stored procedures and functions between the two database platforms and share how to most effectively use them.
While there are common data types used across all database platforms, there are a few differences to be aware of to successfully operate in PostgreSQL. Join Ryan Booz for this webinar on the key differences between data types in SQL Server versus PostgreSQL, and best practices in picking PostgreSQL data types.
Sehen Sie sich jetzt dieses On-Demand-Webinar an, um mehr über die wichtigsten Funktionen von Redgate Monitor Enterprise zu erfahren, darunter: Compliance bei der Serverkonfiguration Sichtbarkeit der Benutzerrechte Integration der REST-API In diesem kurzen Webinar, lernen Sie, wie diese Funktionen es Unternehmen ermöglichen, Sicherheitskonformität sicherzustellen, Einblicke in Benutzerrechte zu gewinnen und das Monitoring nahtlos in bestehende Workflows zu integrieren. Bitte beachten Sie, dass dieses Webinar für Teilnehmer aus der DACH-Region geeignet ist.
