In this insightful interview, Shaun explains the complexities and necessities of high availability for Postgres, especially in the context of cloud deployments. He highlights the evolution of container orchestration tools and their impact on simplifying high availability setups. The conversation also delves into the future of Postgres, with a particular focus on the burgeoning role of AI and vector databases like pgvector. Shaun's expertise and passion for Postgres shine through as he discusses the transformative potential of these technologies and their implications for database management. Don't miss this engaging episode packed with practical insights and forward-looking perspectives!
Cloud Commute offers a deep dive into cloud topics like storage, security, and Kubernetes. Hosted by Chris Engelbert and featuring industry veterans, it covers the latest tools, developments, and releases. Ideal for tech enthusiasts and professionals in DevOps, SecOps, DevSecOps, and engineering.
Show notes:
Guest links & episode links:
- Shaun's LinkedIn: https://www.linkedin.com/in/bonesmoses/
- Shaun's X/Twitter: https://twitter.com/BonesMoses
- Shaun's Blog: https://bonesmoses.org/
- Tembo on LinkedIn: https://www.linkedin.com/company/tembo-inc/
- Tembo on X/Twitter: https://twitter.com/tembo_io
- Tembo: https://tembo.io/
- CloudNativePG: https://cloudnative-pg.io/
- Pacemaker: https://clusterlabs.org/pacemaker/
- Corosync: https://corosync.github.io/corosync/
- BDR (now EDB Postgres Distributed): https://www.enterprisedb.com/products/edb-postgres-distributed
- EnterpriseDB (EDB): https://www.enterprisedb.com/
- Presentation “High Availability with PostgreSQL and Pacemaker”: https://www.youtube.com/watch?v=xxKcEUclhZw , slides: https://wiki.postgresql.org/images/0/07/Ha_postgres.pdf
- Book “PostgreSQL 12 High Availability Cookbook”: https://www.packtpub.com/product/postgresql-12-high-availability-cookbook-third-edition/9781838984854
- Trunk: https://pgt.dev/
- PGXN: https://pgxn.org/
- David E. Wheeler: https://www.linkedin.com/in/theory/
- Adam Hendel: https://www.linkedin.com/in/adam-hendel/
- PGMQ: https://github.com/tembo-io/pgmq
- pg_vectorize: https://github.com/tembo-io/pg_vectorize
- pgvectorscale: https://github.com/timescale/pgvectorscale
- pgvector: https://github.com/pgvector/pgvector
- EFM: https://www.enterprisedb.com/docs/efm/latest/
- repmgr: https://www.repmgr.org/
- Patroni: https://github.com/zalando/patroni
- pg_auto_failover: https://github.com/hapostgres/pg_auto_failover
- Gabriele Bartolini: https://www.linkedin.com/in/gbartolini
- 2ndQuadrant BDR: https://www.enterprisedb.com/products/edb-postgres-distributed
- Pinecone: https://www.pinecone.io/
- Ollama: https://ollama.com/
Follow us on:
🐦 simplyblock Twitter/X: https://x.com/simplyblock_io
👨💻 simplyblock LinkedIn: / simplyblock-io
📹 simplyblock Youtube: / @simplyblock
Know more about us:
🌍 simplyblock Website: https://simplyblock.io/
Simplyblock is an intelligent database storage orchestrator for IO-intensive workloads in Kubernetes, including databases and analytics solutions. A single system connects local NVMe disks, GP3 volumes, and S3 making it easier to handle storage capacity and performance. With the benefits of thin provisioning, storage tiering, and volume pooling, your database workloads get better performance at lower cost without changes to existing AWS infrastructure.
👉 Get started with simplyblock: https://www.simplyblock.io/buy-now
🏪 simplyblock AWS Marketplace: https://aws.amazon.com/marketplace/se...
Key features of simplyblock:
⭐ Smart local NVMe caching to eliminate read I/O latency and speed up database queries
⭐ Intelligent data tiering between high-speed NVMe, flexible Amazon EBS, and cost-effective Amazon S3
⭐ Maximum IOPS and lowest latency on read
⭐ Benefits of thin provisioning, instant copy-on-write clone, compression, deduplication & encryption