Unlocking PostgreSQL for SQL Server Professionals
Bridging the skills gap to migrate and scale quickly with PostgreSQL.
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.
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 series. The content of part 1 is essential for understanding the part 2. In this part 2 we discuss what kind of aggregates can be obtained from a temporal database and how to express these aggregations in the SQL language. The examples in the part 2 are based on table definitions...… Read more
In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in a way that allows you to see not only what the value of any column is currently, but at any point in time that your system is created to handle. In this three part series, I will aim to define what kind of information can be obtained from temporal tables and how to express requests for this information as SQL queries. In this part 1 we explain concepts of temporal databases in general and outline major types of queries you will need for...… Read more
The first two articles in this series demonstrated how PostgreSQL is a capable tool for ELT – taking raw input and transforming it into usable data for querying and analyzing. We used sample data from the Advent of Code 2023 to demonstrate some of the ELT techniques in PostgreSQL. In the first article, we discussed functions and features of SQL in PostgreSQL that can be used together to transform and analyze data. In the second article, we introduced Common Table Expressions (CTE) as a method to build a transformation query one step at a time to improve readability and debugging....… Read more
In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming data for analysis. Over the last few decades, this was traditionally done with a methodology called Extract-Transform-Load (ETL) which usually requires external tools. The goal of ETL is to do the transformation work outside of the database and only import the final form of data that is needed for further analysis and reporting. However, as databases have improved and matured, there are more capabilities to do much of the raw data transformation inside of the database. In doing so, we...… 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
This article demonstrates how to run a preliminary check that issues a warning, or throws an error, if the conditions aren't met for a Flyway migration to succeed. It provides some example checks for PostgreSQL databases that use Flyway SQL callbacks to ensure the server is running the correct PostgreSQL version, or that the database has a required extension installed. Read more
This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like SQL Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and prevent them becoming problems that affect users. Read more
PostgreSQL monitoring is now supported by Redgate SQL Monitor to improve performance and reduce downtime. Read more
Bridging the skills gap to migrate and scale quickly with PostgreSQL.
PGConf NYC 2024 is a 3-day conference packed with user stories and best practices for how to use PostgreSQL, the world’s most advanced open source database. Join us in New York City and connect with other developers, DBAs, administrators, decisions makers, and contributors to the open source PostgreSQL community! PGConf NYC 2024 is September 30th – October 2nd, 2024 at Convene 237 Park Avenue, New York, New York. Register today!
PostgreSQL Europe is proud to announce the 14th Annual PostgreSQL Conference Europe which will be held at the Divani Caravel Hotel in Athens, Greece, on October 23–25, 2024 with an additional day of world-class PostgreSQL training offered on October 22.
Join PostgreSQL advocate Ryan Booz and learn how to boost the performance of your PostgreSQL database estate with Redgate Monitor, including a sneak peak of what else is to come on the road map.
In this session, Grant will cover some of what he has learned, as well as tips and tricks for learning more. Making yourself into a multi-platform data expert just got a tiny bit easier.
Monitoring your PostgreSQL databases is crucial to ensure the overall health and performance of your ecosystem. PostgreSQL provides a wealth of metrics, but which ones are most important to measure and how best should you do this? In this webinar, you will gain insights and strategies to help keep your database environment running smoothly and efficiently so you can avoid some of the most common bottlenecks. Join Ryan Booz, PostgreSQL advocate at Redgate, and discover: The key metrics to measure and how to track these effectively Common performance pitfalls and effective troubleshooting and optimization techniques The available monitoring tools to ...
