Wrote a tool to show conflicting table and row locks in postgres. postgres-locks.husseinnasser.com Pick a pg DDL or DML command and it tells you what is allowed to run concurrently with it, and what does it conflict with (blocks). Tried to list all relevant commands. might missed few.

Love this! Nice job Hussein. I find the format of hearing you read the docs and providing your thoughts to be engaging and even entertaining. :) While I can read the docs myself, it's nice to get your perspectives and thoughts as if we're reading and discussing it together. You provide a lot of little valuable insights along the way.

Hats off to this human being who is serving other human beings.

Brilliant stuff as always. Watching you explaining the docs and listening to your valuable thoughts is a productive time for me :). Thanks for making it!

@lakhveerchahal

Жыл бұрын

PS: I love postgres docs

Thank you for this great video Mr Hussein 🙌

This man is just awesome. Thanks for so much valuable content Hussein.

A reindex needs an ACCESS EXCLUSIVE lock to prevent any reads that may make use of the index that is being reindexed. A create index does not need this because any reads will have no chance to use it, since it does not exist yet. Both will block writes though, unless you can use the CONCURRENTLY clause.

Will come back later. Just found out I'm not good enough to understand it after 15 mins. Good job man

Great effort and awesome video 😊 thanks

Great videos ❤

You are great, it's obvious that you feel software engineering ;) Greetings from Poland

Hussein, why is Postgres your choice among others? I wonder whether I will focus on SQL server or Postgres to get hired as a DBA?

It would be great if someone had a nice demo to show all these conflicts and what operations you are or are not allowed to carry out, maybe something like how you used two docker containers to show MVCC in your database fundamentals course. You might have to find a way to 'pause' a transaction, e.g. if you SELECT one row, the lock won't be there for very long, so you would probably miss it happen.

@jonathanfrias1

8 ай бұрын

begin; select ....; select pg_sleep(10); commit;

At 42:01 Hussein says that he has a whole video about deadlocks. I can't find that one. Does anyone know which video he was referring to?

The timeline says "Advistory Locks". It's "Advisory Locks".

@hnasr

Жыл бұрын

thanks fixed

You are just reading the postgres documentation. Don't do that, we can read that. We need explanation using code. Don't waste our time. I would give -(minus)5/5.

@matiashernangarcia7965

3 ай бұрын

You would be surprised how many developers read any docs at all...

@InvincibleMan99

Ай бұрын

No, just appreciate some one efforts. You can do it yourself. I find this way of presenting information very useful, becz next time you read the doc yourself, it will feel familiar. See a lot of effort is needed to make videos along with full time job.

@AshisRaj

Ай бұрын

No one asked you to make videos ok!. Appreciation should be given to someone who deserves

@InvincibleMan99

Ай бұрын

@@AshisRaj and no one asked you to comment here. He made videos by his own choice. It's his platform. Throw your-vity somewhere else.

@AshisRaj

Ай бұрын

@@InvincibleMan99 no one asked you to be his lawyer. I would certainly do what I feel is correct

Request to do it in mysql