- When a database query is unexpectedly slow (10 Aug 2022)
In this micro post, I would like to share my experience in improving database query time by updating statistics estimates.
- Concurrent write problem (22 Apr 2022)
Concurrency control is one of the most challenging aspects of software development. Sometimes, we have a tendency to wishful thinking and naive beliefs that our advanced toolkit like a web framework, a database or an ORM solve all our issues seamlessly underhood. However, when we tackle non-trivial problem (like concurrent write), we have to demonstrate some understanding how these tools genuinely work (and maybe why they are configured in the specific way).
- How to build PostgreSQL full text search engine in any language (27 Jan 2022)
In this short post I will show step by step how to establish full text search engine in PostgreSQL. Several options like `ilike`, trigrams search and tsearch will be presented.