PG-OS: Multi-Level Rental Management
// Executive Overview
A high-performance backend system built using NestJS to manage large-scale multi-level Paying Guest (PG) operations. The system automates room inventory management, tenant lifecycles, and monthly invoicing routines across multiple properties.
The Challenge
The client's legacy database setup suffered from thread locks and slow response times during monthly invoice cycles. Running ledger aggregations across 10,000+ active rooms caused memory exhaustion and transaction timeouts in the API layers.
Our Engineering Solution
We refactored the backend using a modular NestJS architecture with Redis caching. We optimized PostgreSQL transactions by introducing composite indexes and concurrent material views. Dockerized deployment with isolated workers guarantees invoicing tasks run without degrading real-time tenant API performance.