Category: Learn PostgreSQL

Going deeper into MVCC, WALL and isolation levels definitions and explanations.

[Book “Learn PostgreSQL”] The transaction chapter is the most interesting so far. It expands on the things I already learned from “Designing Data Intensive Application”. I try to write a summary of this chapter once I am done with it. It will cover most interesting topics like:– transaction identifiers (xid) and the wraparound problem– MVCC…

I started reading about transactions but without taking notes. I will write them down tomorrow

I finished chapter about partitioning. I learned about table inheritance and declarative partitioning types. The chapter covered three partitioning strategies – by range, by list and by hash. Unfortunately the examples covered only list and range. The book didn’t cover how to manage partitioning programmatically which is disappointing considering that range partitioning example would require…

I finished chapter about triggers and finally moving on to more interesting topic – Partitioning. The “Triggers” chapter was mainly a dry walkthrough the synopsis. I think I was missing theoretical explanation of how triggers work under the hood.On the other hand “Partitioning” chapter starts with types of partitioning (range, list, hash) – which makes…

I finished the chapter about postgres functions. I feel the syntax is quite cumbersome and I can’t find a good use-case for them now. I imagine they will come handy when combined with triggers or cron jobs. I am looking forward to next chapter about triggers.

Moving on with “Learn PostgresSQL”. Today I went through a major part of “Server-side programming” chapter, including data-types (hstore, json, jsonb, dates and time) and writing functions with SQL and PL/pgSQL. Functions in database seem interesting, I can foresee certain use cases. However they also seem like a serious maintenance effort. Perhaps they require integration…