When it comes to PostgreSQL performance tuning, work_mem is one of those parameters that can make a significant difference. It’s a straightforward concept—memory allocated for query operations—but understanding how to use it effectively can help you optimize your database performance. … Read More

Remember when SQL queries looked like impenetrable walls of nested subqueries? When handling a simple null value required verbose CASE statements, and analyzing data meant wrestling with complex self-joins? If you learned SQL in the early 2000s, you might still … Read More

I have a story about a database crashes due to some malfunction from hard drive. After check, the last backup ran at midnight. In those time period between backup and crash’s time, the system processed 10,000 customer orders, 50,000 product … Read More