LogBook

Category: Thread

  • 2025/07/03 [Learn Postgres]

    Toady finished the part about parallel workers. I could not spend the usual amount of time on the book because of the trip to the office. I hope to cover more tomorrow when I will start the section about indexes.

  • 2025/07/02 [Learn Postgres]

    The “query tuning” chapter is great. I already learned a lot about Postgres planner and optimizer, execution stages (parsing, rewriting, optimization and execution), cost-based optimization and sequential nodes – sequential scan, index nodes and nested loops. Tomorrow I will start with parallel nodes!

  • 2025/07/02 [GADM-api]

    I did serious progress on filtering results by parent administrative unit. Squirrel was giving me hard time because of confusion between “?” and “$1” parameters. Fortunately it was solvable by a single line var psql = squirrel.StatementBuilder.PlaceholderFormat(squirrel.Dollar) I think tomorrow I will finish the filtering feature for feature-collection enspoints.

  • 2025/07/01 [Learn Postgres]

    I finished my notes about VACUUM and therefore the “transactions” chapter itself. Also, I browsed over the “extensions” chapter. I was interesting to learn about the pgxn and pgxs tools for extensions management. However the rest of this chapter won’t be very useful to me. But I am happy to move to the next one…

  • 2025/07/01 [GADM-api]

    Hello July! I refactored handler configuration by clearly separating “static” configuration values from parameters provided by the user. The code is now ready to support filtering by gid column.

  • 2025/06/30 [GADM-api]

    My trip to Poland over the weekend put in test my daily habits. Nevertheless I managed to do at leas a small progress every day. Tomorrow I am back to waking up at 6am and focusing on personal development early in the morning. It’s important to make at least a small progress every day, especially…

  • 2025/06/30 [Learn Postgres]

    I wrote down notes about WAL and checkpoints. Tomorrow I hope to complete notes about VACUUM and move on to next chapters – “Extensions”.

  • 2025/06/29 [GADM-api]

    I managed to progress the gadm-api project a bit when I was flying back to Amsterdam today. Otherwise it is very difficult to keep the habit of daily updates when traveling. The progress on the Postgres book had to be paused since traveling with 700 page book is very inconvinient. [GADM-api] I started working on…

  • 2025/06/27 [Learn Postgres]

    I am still writing down notes on “Transactions” chapter.

  • 2025/06/27 [GADM-api]

    I added a structured approach for url creation and did some progress on “next url” feature. Also I unified the wording around pagination.