Understanding Vector Databases and their Indexing Innovations

Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA, and product manager for over 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.

Ryan is a long-time DBA, starting with MySQL and Postgres in the late ’90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when learning something new about the data platform or teaching others about the technology he loves.

Topics of Discussion:

[4:10] What made Ryan a database guy?

[6:11] CodeMash.

[6:58] Discovering the potential of SQL Server.

[12:02] The state of the database in 2025 and the things generalist developers should know.

[15:27] The challenge of interfacing between database types.

[19:57] Is Microsoft Fabric the future?

[22:44] Postgres for .NET developers.

[24:46] Nuances of migrating from SQL Server to Postgres.

[26:01] Postgres resources for data professionals.

[35:29] Postgres and its innovative edge.

[38:30] What is a vector database?

[39:45] The power of Postgres indexing.

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

Programming with Palermo — New Video Podcast! Email us at programming@palermo.net.

Clear Measure, Inc. (Sponsor)

.NET DevOps for Azure: A Developer’s Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon!

Jeffrey Palermo’s Twitter — Follow to stay informed about future events!

Ep 245 with Ryan Booz

Figuring Out Fabric

SQLGene Training

Introduction to PostgreSQL for the data professional. Kindle Edition

Postgres Playground

pgEdge

“Name Collision of the Year”

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.