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

Nice! Now I don’t have to use web3 and store my data on crypto and pay per request and have huge latencies and non acid transactions. 😂

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

MOOOORE

Why would you use preared statements instead of stored procedures? They are automatically "prepared" and don't need to be recreated in every session

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.

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

people are not using indexes in an SQL service?
also what people should learn about indexes
if you create an index on a column the db will search faster after it
if you have 3 where conditions, for example, then you need to create an index for those 3 colum combination for speed

Prepared statements STILL don't work with pgbouncer and most other db proxies. No thanks.

Any book recommendations on how to optimize PostgreSQL?

What tool are you using the terminal looks so good

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

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.

Awesome video

🔥any good resources to learn more?

I hack apis .. generally mysql and more graoh ql these days .. if you ever want to collab just let me know .. peace ✌️

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

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

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)

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