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.
New Book
Ryan Booz & Grant Fritchey
While the documentation around PostgreSQL is detailed and technically rich, finding a simple, clear path to learning what it is, what it does, and how to use it can be challenging. This book seeks to help with that challenge.
From getting your first instance, or cluster, up and running, to backups, to server configurations, we cover all the basics of how to get started within PostgreSQL. You'll learn about processing languages, monitoring, indexes and more. Every chapter provides fundamental knowledge and guidance to quickly get you up and running in PostgreSQL.
Get your free copy
The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational rather than just relational database management system, and briefly discuss what kind of object-oriented features it offers. We demonstrate how these features can be used to manage hierarchies, and how applications can benefit using them. The discussion is illustrated with examples of SQL code based on the postgres_air database [6, https://github.com/hettie-d/postgres_air]. There are many ways to implement a hierarchy in a relational database. Techniques with names like adjacency lists and nested sets, not to mention some other RDBMS have built methods of managing...… Read more
It’s a tale as old as time. You want to read data. Your mate wants to write data. You’re stepping on each other’s toes, all the time. When we’re talking about relational data stores, one aspect that makes them what they are is the need to comply with the ACID properties. These are: A whole lot of effort is then made to build databases that both allow you to meet the necessary ACID properties while simultaneously letting lots of people into your database. PostgreSQL does this through the Multi-version Concurrency Control (MVCC). In this article we’ll discuss what MVCC is...… Read more
In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of this series, we used the GiST index type – and its lesser known cousin: SP-GiST – to turbocharge the performance of overlap queries. But GiST indexes are extremely versatile, with uses far beyond the examples I have used so far. In this final article, we’ll explore some of the many other ways they can be used. Stuck in the Middle With You We’ve used only one operator in all our queries so far: the “&&” operator, which returns true if...… Read more
A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents. String data types allow you to do just that and store and represent text. They handle everything from simple names and addresses to complex data. A string is simply a sequence of characters. These characters can be letters, numbers, symbols, or even spaces. For example, “Simple Talk”, “MySQL and PostgreSQL”, “1234” are all strings. Think of each character as a building block. A string is made up of these blocks, arranged in a specific order. String data types are important...… 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.
Treffen Sie Redgate auf dem Swiss PGDay 2025 Am 26. Juni ist es wieder so weit: Der Swiss PGDay bringt die PostgreSQL-Community in der Schweiz zusammen – und Redgate ist als Sponsor mit dabei! Freuen Sie sich auf spannende Vorträge, neue Impulse und den Austausch mit Gleichgesinnten. Besuchen Sie uns an unserem Stand und: Entdecken Sie, wie Redgate Sie bei der Entwicklung und Bereitstellung Ihrer PostgreSQL-Datenbanken unterstützen kann. Sprechen Sie mit unserem Team über Ihre Herausforderungen und Erfahrungen mit PostgreSQL. Nehmen Sie an unserem Gewinnspiel teil und sichern Sie sich tolle Redgate-Goodies. Wir freuen uns auf Ihren Besuch in Rapperswil! ...
Join us for this online hands-on session exploring how you can automate your database releases in under 2 hours – a fully interactive, lab-focused session where you’ll spend dedicated time using Redgate’s tools alongside experts from the field.
Redgate auf dem PGDay Austria 2025 Der PGDay Austria bringt PostgreSQL-Profis, Entwickler:innen und Datenbank-Enthusiast:innen aus ganz Europa zusammen – mitten im Herzen Wiens. Redgate ist als Sponsor vor Ort und freut sich darauf, mit Ihnen ins Gespräch zu kommen. An unserem Stand erhalten Sie Einblicke in unsere neuesten Tools für die PostgreSQL-Entwicklung und das Monitoring. Tauschen Sie sich mit unserem Team über Ihre aktuellen Projekte und Herausforderungen aus – und nutzen Sie die Gelegenheit, an unserem Gewinnspiel teilzunehmen. Natürlich haben wir auch wieder exklusiven Redgate-Swag für Sie dabei. Ob Sie bereits mit Redgate arbeiten oder unsere Lösungen erst kennenlernen möchten ...
