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(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
Range queries are a very common task in SQL: selecting dates, numbers, or even text values that fall within some specified range. For instance: all loan applications for the month of March, or all sales transactions between $50 and $500. SQL developers are generally adept at writing such queries and indexing them to ensure they perform well. But when the requirements are changed slightly — to compare two ranges of values to find where they overlap — it’s suddenly a whole new ballgame. These so-called “overlap queries” are trickier than they appear. Overlap Queries The most common overlap queries involve...… Read more
Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only as a means to increase performance on large tables. While it’s certainly useful for this, it’s also an invaluable tool for solving common data maintenance problems. In this article, we’ll examine the feature from this perspective. Let’s consider a common situation: a table continually ingesting time series data ordered chronologically: purchase orders, forum posts, time-series data, whatever. Most systems contain more than one table like this. And because we live in a world of Big Data, these tables can contain...… 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
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 Redgate 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
The features available within SQL Server and PostgreSQL for functions and procedures are different in some surprising ways. Join Grant Fritchey and Ryan Booz for this live webinar as they uncover the secrets behind stored procedures and functions between the two database platforms and share how to most effectively use them.
Connect, share & learn with peers and thought leaders while celebrating all things data for a week of learning and networking opportunities. Add PASS Summit to your calendar: Outlook/Google PASS Summit brings together thousands of data platform professionals together in Seattle, WA. The main conference takes places over three full days (Wedneday Nov. 6 – Friday Nov. 8, 2024) with two additional pre-con days also available. To see the full list of this year’s awesome sessions and speakers, click here. This year’s event will take place in a brand new venue, Seattle Convention Center’s state-of-the-art Summit building. Tickets are now ...
Join us for this hands-on 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.
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.
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 new, live 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.
