Improving performance in a hierarchical SQL table structure with column propagation
Column propagation can help address the typical performance issues associated with hierarchical table structures which are inherently slow. Let’s learn how!
Partitioning a billion-row table of soccer data using data context
Why you should study your application domain when defining efficient partitioning criteria for your database.
How to fix a sequence when it goes out of sync in Postgres
Let's learn how to identify and then fix the out-of-sync issue leading to the "duplicate key value violates unique constraint" message error that occurs with PostgreSQL sequences.
Improving performance with SQL aggregate functions
SQL aggregate functions helped me take the performance of my backend application to the next level and avoid the bottlenecks that were slowing it down.