Datascape Podcast Episode 18 – Getting to know Postgres

Posted in: Technical Track

On the show today we welcome Álvaro Hernández, the founder of Ongress. Ongress is a database and research company where they work mainly with Postgres in the database space, developing and researching new products. They also provide professional services for Postgres, such as support, maintenance, and training. Previously, Álvaro worked with ToroDB, which is a database created in Spain and the first database that connect the NoSQL world with the SQL world, moving data from MongoDB to Postgres.

With the recent release of Postgres Version 10, this is a great time to get to know the product better. Álvaro joins us to share his thoughts on some of the trends in the database space and when to choose Postgres. We also dive into the top features of the latest Postgres version, as well as conference opportunities to get to know Postgres even better. Keep listening to learn more.

Key points from this episode:

  • An overview of Álvaro’s company and his career journey.
  • Understanding the trends and how Postgres is competing with other databases.
  • Find out how Postgres compares to the Oracle Database.
  • Choosing between Postgres and MySQL when doing a migration from Oracle.
  • What attracted Álvaro to working with Postgres.
  • The largest storage server that Álvaro has previously worked with.
  • Why Postgres and relational databases do better with OLTP.
  • Support available and provided for the Postgres ecosystem.
  • Unique nature of Postgres’ locking and blocking strategy that facilities OLTP workload.
  • The most prominent challenge of managing Postgres.
  • Performing ETL interacting with Postgres.
  • Top recommend resources within the Postgres community.
  • Best features and technologies of the latest version of Postgres.
  • The use case for why you would use partitioning.
  • Using Foreign Data Wrappers (FDW’s) with Postgres.
  • Some of the best learning resources for Postgres.
  • The book that has had the biggest impact on Álvaro’s career.
  • And much more!

Links mentioned in today’s episode:

Álvaro Hernández
Álvaro on Twitter
Ingres Database
Postgres
ToroDB
MongoDB
MySQL
Oracle
Citus Data
pg_stat_statements
Patroni
PGCon
PGConf New York
PG European Conference
PG Conference Ottawa
BDR by 2ndQuadrant
PostgreSQL Documentation
The Art of Computer Programming
SSH
Joker Conference
Scale
FOSDEM
Postgres Moscow Conference

 

email

Interested in working with Chris? Schedule a tech call.

About the Author

Director of Consulting

Chris Presley loves order—making him a premier Microsoft SQL Server expert. Not only has he programmed and administered SQL Server, but he has also shared his expertise and passion with budding DBAs as SQL Server instructor at Conestoga College in Kitchener, Ontario. Drawing on his strong disaster-recovery skills, he monitors production environments to swiftly detect and resolve problems before they arise. A self-described adrenaline junkie, Chris likes tackling the biggest database problems and putting out the toughest fires—and hitting the road on his motorcycle.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *