5 Secrets for making PostgreSQL run BLAZING FAST. How to improve database performance.

There's an approach in here for everyone! PostgreSQL is one of the most versatile SQL databases but often does not provide performance out of the box.

Fortunately, there are some easy approaches to improve the speed of database queries when it comes to PostgreSQL. In this video, we look at 5 different approaches which can be used based on your requirements.

#postgresql #database #optimization

My socials:

Please consider supporting me as well!

[luispalacios]

I discovered your channel a few days ago; it's been amazing. Keep up the excellent work.

[makkusu]

Really well made video. Staying here for more!

[enossalar]

Thank you for the detailed explanation

[HrHaakon]

Prepared statements should not be used because they're faster. They should be used because they're much safer.
The speed increase is just a free bonus.

[tibzdankan]

"You can lower the roof and feel the wind in your hair", I love Dreams of Code, I love PostgreSQL

[SirJagerYT]

Suggestion for next sql video is "how to vectorize sql database for fast searching"

[heroe]

Thanks for the video, very good content and well edited, I'd just recommend putting more dynamism in your voice to match the pacing

[pss_crs]

I would like to see content possible and good way to implement multi tenant on postgres

[and_rotate]

I want to be from ur first subscribers so when u reach a million in the next year i will comment i was here when he was getting started (i was here at 5k)

[prathameshjoshi]

slight addition to COPY. you can use \copy from client if you don't have access to store input files on server. i.e. You can locally stream csv to server.

[dungeon]

I am wondering how did you insert 20 million row into a table, where did you get that data from

[xetera]

Seems kinda wild that the first point is prepared statements. It's not even a drop in the bucket for performance optimizations compared to indexing

[gjermundification]

Which language would I write a postgreSQL extension in? PL/SQL? ECMA? Python?

[FelipeCampelo]

I have restricted my studies to data manipulation tasks. There is a lot to take a look on data definition and control yet!

[budmonk]

I'm from the Oracle world, a lot of familiar concepts

[xucongzhan]

Nice and informative vid.
Care to share what mic you are using? Sounds very nice

[techno]

Your index explaination is not entirely correct. Postgres does offer hash-based indexes which are a lot closer to your explaination but the default index type (which you used in your creation example) is a B-Tree index, the data structure is very different.

Paritions don't do anything meaningful to speed up writes, they would only speed up reads. Instead of scanning a whole table for a record, you only need to scan the single partition (assuming you're querying a single key) where you know your record lives in. It's the same concept as database sharding, but on one machine instead of multiple.

[ujjwalaggarwal]

you should add a timestamp for the copy statement part of the video

[Fanaro]

Any book recommendations on how to optimize PostgreSQL?

[ongayijohnian]

Mahn, please do the dadbod plugins for NvChad