📝 Parottasalna Blog
248 practical articles on backend engineering, system design, databases, Docker, Python, AI and DSA, explained simply.
6 articles tagged #Postgres · Clear filters
Learning Notes #57 - Partial Indexing in Postgres
Today, i learnt about partial indexing in postgres, how its optimizes the indexing process to filter subset of table more efficiently. In this blog, …
DatabaseLearning Notes #42 - Optimistic Lock and Pessimistic Lock | Postgres Locks
Today, I learnt about concurrency control on database from application level. Two widely used strategies to manage concurrency are optimistic locking…
DatabaseLearning Notes #41 - Shared Lock and Exclusive Locks | Postgres
Today, I learnt about various locking mechanism to prevent double update. In this blog, i make notes on Shared Lock and Exclusive Lock for my future …
DatabaseLearning Notes #28 - Unlogged Table in Postgres
Today, As part of daily reading, i came across https://raphaeldelio.com/2024/07/14/can-postgres-replace-redis-as-a-cache/ where they discussing about…
DatabaseLearning Notes #20 - Partitioning (data) With Postgres
Early Morning today, i watched a video on partitioning and sharding. In that video, Arpit explained the limitation of Vertical Scaling and ways to in…
ProgrammingPostgres Ep 2 : Amutha Hotel and Issues with Flat Files
Once upon a time in ooty, there was a small business called “Amutha Hotel,” run by a passionate baker named Saravanan. Saravanan bakery was famous fo…