Squeeze Your System, 1 Million Connections, Indexing LIKE, pgvector HNSW | Scaling Postgres 278

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss how to squeeze the most out of your database, achieving 1 million connections to Postgres, how to use indexes with LIKE and pgvector HNSW index performance.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
01:10 - Squeeze the hell out of the system you have
03:23 - Comments on Squeeze the hell out of the system you have
04:22 - Supavisor: Scaling Postgres to 1 Million Connections
07:11 - Indexing "Like" In PostgreSQL and Oracle
09:05 - An Early Look at HNSW Performance with PGVector
11:39 - Sharding
12:45 - Fun with PostgreSQL Puzzles: Recursive Functions with Animations
12:59 - How we Reduced Downtime by 100x: Supplementing pgBackrest EBS Snapshots
14:14 - How an AWS Aurora feature cut our DB costs by 90%
14:54 - Episode 6 highlights of Path To Citus Con podcast w/ Chelsea Dole & Floor Drees
15:14 - Balancing Act: Achieving High Availability with HAProxy for PostgreSQL
15:32 - Outro

#postgres #postgresql

[smyrnian_]

Interviews are great idea to get more insight!

[RU-qvjl]

I think maybe a mix of different formats. I will say that I really appreciate what you share already. If you want to try something else or feel that it is a bit stale then try whatever. At the end of the day no-one can know what it would be like unless you are willing to try it. I am sure that as long as the content remains great then any format will work well 👍

[jimjonesbr]

I love the idea of interviews! I would be very interested on interviews of PostgreSQL Hackers about the patches their working on. Sometimes it can get quite hard for the general public to understand what the items in the commitfest actually mean to the PostgreSQL community. So having it explained by the hackers themselves might even encourage other people to join the discussion, or even test and review it.

Big fan of the show's format! I don't think I've missed any of the 278 episodes of Scaling Postgres ;)

[kirkwolak]

How about 2 videos. I love this one for catching up. MAYBE you let us vote on which ones you could do a deep dive on later? But one interview and one Summary would be great without making my head spin...

[richarddemke]

I wouldn’t mind a tutorial or “how to do this” within the context of the article. Your videos are great and this would be the cherry on top. Doesn’t have to be for every one of them. Just one. You choose

[kevanschwitzer]

I agree with your suggestions at the beginning to go deeper with less breadth covered. When I saw the first article you introduced, it sounded like you've had similar experiences about optimizing database performance. Same in my experience too.. Going into your experiences and providing additional insight/context would be valuable to listeners and also showcase your expertise. Thanks for the content.

[marcuslima]

I agree with you on reducing the number of articles on videos (but keeping them for the blog). As a beginner in PostgreSQL, I would appreciate some basic concept explanations. You could provide a brief overview of the concepts and then delve deeper into the article. What do you think about this approach?

[lukec]

I like the idea of interviews maybe you could mix the episode construction vary the episodes between articles & posts you think are valuable, interviews and more in-depth discussions.

[robertcannon]

Thank you for your channel. Appreciate your work. Is there a discord? Would be great to do a question and answer session from viewers.