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.

Learn how to significantly enhance your application's performance by implementing connection pooling in Go. Explore best practices, detailed code snippets, and real-world benchmarks using YugabyteDB to efficiently manage database interactions and ensure your application scales smoothly under heavy load.

Optimize DBeaver for better performance and usability with these expert tips. Learn how to tune memory settings, enhance the user interface, enable autosave, and configure SQL formatting for a smoother experience.

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.

"TEXT vs VARCHAR: Which to use when?"

Learn about Flyway logging options and debugging techniques to troubleshoot issues and gain insights into the migration process in Yugabyte.

Discover how Flyway and Yugabyte can make database schema changes easier with a comprehensive guide to CLI commands for seamless migrations.

Optimising PostgreSQL performance in distributed SQL environments can be a complex and challenging task, especially when using a platform like Yugabyte

This post provides a detailed comparison of the two sharding methods and provides examples of when to use each one, along with SQL examples. It also explains the underlying hardware and DocDB considerations while using sharding in YugabyteDB.
The excitement around distributed SQL is increasing as more and more apps move to the cloud. However, there are also a lot of questions that come up when working with these databases. Questions like: What are the use cases for…