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
Simple-Talk is proud to sponsor PGDay Chicago. PGDay Chicago is a non–profit, community–run conference series in the United States focused on PostgreSQL, the world’s leading open source database. This conference delivers one day packed with presentations about PostgreSQL and related technologies and the usual hallway and social track. For more details, go to: https://2025.pgdaychicago.org/
Redgate is delighted to be sponsoring at PostgreSQL Conference Germany! Join us at the 9th annual PostgreSQL Conference in Berlin, Germany, May 8-9, 2025. This is the second largest PostgreSQL conference in Europe. PostgreSQL Conference is a unique chance for German and European PostgreSQL users and developers to catch up, learn, build relationships, get to know each other and consolidate a real network of professionals that use and work with PostgreSQL. Stop by the Redgate booth to speak to our friendly crew about how we can help you on your end-to-end database DevOps journey. Register here.
Chris Hawkins and Huxley Kendell, Solution Engineers at Redgate, are back to lead you through a hands-on session with Flyway AutoPilot, this time featuring PostgreSQL. This interactive, ready-made sample project will allow you to experience using Redgate Flyway Enterprise in under 30 minutes.
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! ...
