Recent PostgreSQL articles on Simple Talk

• 

  Ryan Booz

  April 22, 2024

  Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3

  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

• 

  Ryan Booz

  April 8, 2024

  Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2

  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

• 

  Ryan Booz

  March 12, 2024

  Transforming and Analyzing Data in PostgreSQL

  In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued skill. Over the last couple of years, I’ve learned how useful many of the data manipulation functions in PostgreSQL can supercharge your data transformation and analysis process, using just PostgreSQL and SQL. For the last couple of decades, “Extract Transform Load” (ETL) has been the primary method for manipulating and analyzing the results. In most cases, ETL relies on an external toolset to help acquire different forms of data, slicing and dicing it into a form suitable for relational databases, Read more

• 

  Grant Fritchey

  February 15, 2024

  Functions and Procedures: Learning PostgreSQL with Grant

  One of the most useful constructs in SQL Server is the stored procedure. It gives you a way to do several things. First up, you can store code within the database. Next, you can parameterize queries so that you’re not hard coding or generating ad hoc queries every time you want to call them. You can put in transaction handling, multiple result sets, security and more. They truly are a useful tool. So, of course, I went straight to CREATE PROCEDURE in PostgreSQL. I begin reading about procedures in PostgreSQL and I’m suddenly hit with a revelation. Procedures can’t return Read more

PostgreSQL events at Redgate

• Frankfurt am Main
• Workshop
• Database DevOps

DevOps in a Day Frankfurt am Main

Join us in Frankfurt!  Spend half a day with our experts who will prepare you for your DevOps journey by guiding you through how Redgate’s tools can help to bridge the gap between development and operations. DevOps is a collection of practices and tools that enable an organization to get an idea to value as quickly and safely as possible. Database DevOps is more complex than software or infrastructure DevOps as teams need to take into consideration the live data stored within the environment. However, once mastered, this can unlock the full value of your wider DevOps project. What will ...

• May 21, 2024

  12:00pm - 5:00pm CEST

Register

• Webinar
• PostgreSQL Monitoring

Monitoring PostgreSQL with Redgate Monitor

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.

• May 22, 2024

  10:00am - 11:00am CT

• May 22, 2024

  4:00pm - 5:00pm BST

Register

Previous PostgreSQL events at Redgate

• Webinar
• PostgreSQL

PostgreSQL 101: Database monitoring and optimization

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 ...

• Webinar
• PostgreSQL

PostgreSQL 101: An introduction to Multi-Version Concurrency Control and Vacuum

In modern relational databases, Multi-Version Concurrency Control (MVCC) is used to allow concurrent access to data in a non-blocking way. PostgreSQL’s implementation is unique and powerful, but also utilizes a process called vacuuming to efficiently maintain data versions. Both MVCC and vacuuming are essential concepts to understand when using PostgreSQL. In this webinar, find out what settings and processes to tune for optimal performance. Join Ryan Booz, PostgreSQL advocate at Redgate, and discover: • How Multi-Version Concurrency Control is implemented in PostgreSQL • The role of vacuuming to keep PostgreSQL running efficiently • The first vacuum settings to tune when ...

• Webinar
• PostgreSQL

PostgreSQL 101: A guide to PostgreSQL documentation & useful resources

It can be a daunting task for new users to get to grips with PostgreSQL documentation, particularly if you are not from a developer background. If you are not sure where to start, we are here to help break down the different resources available so you can make the most of them. Join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover: How to navigate PostgreSQL documentation The essential things you need to know about PostgreSQL documentation Other useful learning resources to help make your journey to using PostgreSQL easier