Doug Ortiz



Reading time: 8 minutes

Tags:   postgresql (208)   ai (3)   ml (1)   llm (1)   mlops (1)   llmops (1)   devops (3)   bigdata (1)   databases (9)   data (1)  
Category:   interviews   
Interview conducted by: Andreas Scherbaum

PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here.

Please tell us about yourself, and where you are from.

Consider myself a Technologist first and foremost that enjoys immersing into new and emerging technologies and trends. As to where I am from, I am originally a New Yorker that has moved around multiple continents and the USA.

Doug Ortiz
Doug Ortiz

How do you spend your free time? What are your hobbies?

Enjoy spending my time going for a good walk, doing some yoga, stand up paddleboarding, and meditating.

Any exercises you do regularly?

Regularly walk, yoga, kettlebells.

Any Social Media channels of yours we should be aware of?

Are you known by a nickname in the community? If yes, what’s the history?

Tried going by Douglas, it was too much to handle for where I was living at a point in time there were multiple attempts to have it reduced down to “D” but that did not seem like a good nickname for me so kept it at “Doug”.

Last book you read? Or a book you want to recommend to readers?

The End of the World Is Just the Beginning - Mapping the Collapse of Globalization by Peter Zeihan

The 48 laws of Power - Robert Greene

The first book is a very interesting geopolitical analysis of what it means for the end of globalization for the entire world. The second one, I find fascinating because the author has had many books and he focuses with this book on understanding and wielding power. They might not be for everyone, but I do consider them interesting nonetheless.

Favorite movie, or show?

Star Trek - 2009 Reacher - TV Show

Best music, best song?

Have always been a fan of 80s music. My favorites are both from Survivor: Eye of the tiger, In the burning hearts.

Best food?

Enjoy all types, always willing to give any type of food a try. My top two ones are: Chinese, and Indian.

Best drink? Non-alcoholic or alcoholic?

A good strong cortado (coffee), a godfather or a good wine.

What does your ideal weekend look like?

Go for a good walk, enjoy a glass of wine and a steak, and last but not least code an interesting application.

What’s still on your bucket list?

Travel the world, go places where are little known, expand as much as possible any and all life experiences.

What is the best advice you ever got?

Do not focus on the now, focus on where you want to be.

It took me some time to digest what this meant, from my point of view it ended up meaning to me to not focus on the tribulations of this point in time; instead plan and aim for the end goal is.

When did you start using PostgreSQL, and why?

Started working with PostgreSQL in 2016, when I was in the midst of obtaining my Data Science and Big Data certifications. The Data Science community already had a strong inclination and love for PostgreSQL, once I began utilizing PostgreSQL there was no going back. Have been involved with PostgreSQL one way or the other since then.

Do you remember which version of PostgreSQL you started with?

9.6, and 10.

Yes, I have definitely studied at a University. Do not regret the experience, I learned a lot from teachers, fellow peers, and friends. The Master’s degree was much more enjoyable than the Bachelor’s degree. Both Bachelor’s and Master’s are IT and computer related, specifically: “Relational Databases”. My education has certainly and always helped greatly, because data is everywhere.

What other databases are you using? Which one is your favorite?

PostgreSQL is my favorite, but I would say that vector databases have certainly been taking a lot of my time for the last 2 years. And, have become a steady staple as well.

Multiple projects, but mostly focused on: Artificial Intelligence, Machine Learning, Large Language Models, and Vector Databases. All of the projects have been interacting with data, with and without PostgreSQL.

How do you contribute to PostgreSQL?

Help spread the word through podcasts, youtube videos, blog posts, open source contributions, etc.

Any contributions to PostgreSQL which do not involve writing code?

Podcasts, YouTube videos, and blog posts.

What is your favorite PostgreSQL extension?

pg_stat_statements, and PGVector.

My top PostgreSQL extensions are pg_stat_statements and pgvector because they perfectly showcase PostgreSQL’s adaptability. The first acts like a built-in performance detective, continuously tracking query patterns to identify slow operations – this extension is essential for keeping systems running smoothly. The second extension transforms Postgres into an AI powerhouse, letting developers store machine learning embeddings (like those from ChatGPT) and run lightning-fast “find similar” searches right alongside regular data.

These two extensions together, cover both ends of the modern app spectrum: pg_stat_statements keeps traditional databases lean and efficient, while pgvector future-proofs projects with semantic search capabilities – all without sacrificing PostgreSQL’s legendary reliability.

What is the most annoying PostgreSQL thing you can think of? And any chance to fix it?

Have found myself quite annoyed with the “Connection Limits”, particularly when needing resource utilization and availability. While max_connections is a band aid the real fix is recurring to a connection pooler.

What is the feature you like most in the latest PostgreSQL version?

MERGE, reason being it is so efficient to perform multiple data updates, inserts, at the same time within a single statement making it efficient and reducing round back trips.

Adding to that, what feature/mechanism would you like to see in PostgreSQL? And why?

Incorporation of a built-in connection pooler and multi-master replication. These two are the most useful features that would top my list at least.

Should PostgreSQL have a built-in connection pooler?

Yes, at least it should be optional.

Should PostgreSQL have built-in multi-master replication?

Yes, also should be optional at least.

PostgreSQL should absolutely have built-in multi-master replication. Modern apps demand always-on availability and geographic distribution, these are features competing RDBMS already offer. While current third-party tools work, their setups can feel ‘bolted on.’ Native integration would simplify operations, reduce conflict resolution headaches, and add an additional reason why PostgreSQL is a strong competitor that can go head-to-head with other databases in enterprise and edge computing.

Making it optional is key: not every workload needs this overhead, and teams should choose consistency models based on their needs. If implemented thoughtfully, this could be a game-changer because it would be balancing PostgreSQL’s stability with the distributed realities of cloud-native development. These additions are not easy to add, but it is a necessary evolution for PostgreSQL when aiming to power tomorrow’s global applications.

Could you describe your PostgreSQL development toolbox?

Do enjoy utilizing the command line as much as possible. To list a few: command line, vi, psql, and whichever programming language command line tools I am utilizing. If I need an IDE, I sometimes utilize VS Codium. For monitoring: pg_stat_statements, and some other command line utilities: pg_dump, pg_restore, pg_basebackup.

Which skills are a must have for a PostgreSQL developer/user?

psql is mandatory from my perspective, and all the other related command line tools related to PostgreSQL.

Do you use any git best practices, which makes working with PostgreSQL easier?

Off the top of my head: branching strategies, commit hygiene, CI/CD integration.

Which PostgreSQL conferences do you visit? Do you submit talks?

PGConf.EU Berlin 2022 and SCaLE 2023. Have not been able to submit for a couple of years, and my schedule has been quite hectic.

Do you think PostgreSQL has a high entry barrier?

It might be frightening since there is a lot of preparation upfront, but would not consider it a high entry barrier. The community is very supportive and there are many resources such as the documentation, which can be daunting but it eventually grows on you. That was the reason that led me to launch my YouTube channel to provide videos that would alleviate as much as possible the issues that many PostgreSQL resources confront when starting.

What is your advice for people who want to start PostgreSQL developing - as in, contributing to the project. Where and how should they start?

Start preparing prior instead of jumping into it.

Do you think PostgreSQL will be here for many years in the future?

Have no doubt it will be here for many years to come, curious and excited about what the future holds for PostgreSQL.

Would you recommend PostgreSQL for business, or for side projects?

It is a reliable and robust database that you can use for any project or type of application.

Are you reading the -hackers mailinglist? Any other list?

I do follow it, there can be a lot to keep up with.

What is your opinion on ORMs?

Would say either stay away from them or utilize them sparingly and purposefully.

SQL versus NoSQL databases?

Each has their purpose and it largely depends on your architecture and application requirements.

What other places do you hang out?

LinkedIn, Slack

Which other Open Source projects are you involved or interested in?

Have contributed recently to the Voxel51 tool, in particular the pgvector integration.

Anything else you like to add?

PostgreSQL is strong and robust, no need to look at any other RDBMS!


Share: