Blog

Bufisa Blog

Follow along with us as we share our experiences in the industry - the highs, the lows, and everything that falls in between.

Optimizing Complex Queries in PostgreSQL by Utilizing View and Materialized View

The Performance Paradox Have you ever experiencing this problem? You’ve just shipped a beautiful dashboard feature, your code is clean, your business logic is neatly organized in your application layer, and everything works perfectly, but when real users start hitting … Read More

Featured Post

Best Practice of Index Management in PostgreSQL

You’ve just deployed your application to production, and everything seems fine. Then, as your user base grows, queries that once took milliseconds start taking seconds. Your database is working harder, but getting slower. Sound familiar? The culprit is often missing … Read More

Featured Post

PostgreSQL High Availability on Single Hardware for Prototype and Learning

When students and engineers first encounter the concept of high availability, they often face a chicken-and-egg problem: they need to understand distributed systems to build them, but they need to build them to understand them. Running a PostgreSQL cluster on … Read More

Featured Post