I Trusted PostgreSQL Advice on YugabyteDB. Production Switched to Sequential Scans.
A YugabyteDB maintenance operation succeeded cleanly but poisoned planner statistics, causing production queries to fall back to sequential scans.
A YugabyteDB maintenance operation succeeded cleanly but poisoned planner statistics, causing production queries to fall back to sequential scans.

In this blog, we explore database locking mechanisms in an airline seat booking system using Go and PostgreSQL/YugabyteDB. Learn how to handle concurrent transactions with various locking strategies for data consistency.

Dealing with long-running jobs in Spring Batch can be tricky, especially when it comes to managing database connections and transactions. In our latest post on Developer’s Coffee, we dive into a real-world issue we faced with a Spring Batch job that timed out due to connection limits. Discover how we tackled the problem by tweaking HikariCP settings and adjusting load balancer timeouts to ensure smooth and reliable batch processing. Read on to learn more about our solutions and how you can apply them to your projects.