2026-06-16 00:00
Kubernetes excels in managing workloads at scale through feedback loops. Operators act as feedback controllers, reconciling desired states, similar to a thermostat maintaining temperature. The article explains how to implement these loops, starting with running a Postgres database manually before transitioning to Kubernetes. Understanding the gap between desired and actual states is crucial for effective database management. 🔧📊 #Kubernetes #DevOps #DatabaseManagement #CloudComputing...
Source: PlanetScale Blog
Fatih Arslan
2026-06-15 00:00
🔍 Monitor your database activity in real-time with the new Connections feature! Connections allows you to manage active sessions for Postgres and Vitess databases, helping you identify locking patterns and debug issues efficiently. Say goodbye to manual monitoring and looping queries. With an interactive live view, you can sort sessions and quickly access essential details like Process ID and status. #DatabaseManagement #Postgres #Vitess #Debugging #TechTools
Source: PlanetScale Blog
Brett Warminski
2026-06-11 00:00
Large DELETE operations in Postgres can create more work instead of reclaiming space. Instead of deleting individual rows, consider structuring your database to use DROP TABLE or TRUNCATE for efficient data removal. When rows are deleted, they don't immediately free up disk space and can impact other transactions. This is due to Postgres' Multi-Version Concurrency Control (MVCC) system. For applications needing large deletions, adopting a schema that supports DROP TABLE can enhance...
Source: PlanetScale Blog
Tom Pang
2026-05-14 00:00
Optimizing database queries can significantly improve application performance while reducing costs. 💻💰 Egress refers to the data transferred out from your database, which often incurs costs with cloud providers. To minimize egress, focus on fetching only necessary data and reducing the frequency of requests. 📊 Common issues include retrieving too much data or making unbounded queries. Instead, limit your queries to specific columns and apply pagination for better efficiency. 📉 For more...
Source: PlanetScale Blog
Simeon Griggs
2026-05-07 00:00
🚀 Discover how PlanetScale Insights can enhance your database performance! This tool offers real-time data on query performance, helping you identify issues in your applications. With metrics like p50, p95, and p99, you can pinpoint slow queries that affect user experience. Explore trends and isolate performance problems with ease. Check out the detailed query list for deeper insights! 📊 #DatabasePerformance #PlanetScale #DataInsights #TechTools #SoftwareDevelopment
Source: PlanetScale Blog
Simeon Griggs
2026-04-21 00:00
Exploring multi-tenancy in Postgres? This article outlines three key approaches for managing tenant data within a single database cluster. 1️⃣ **Row-level Isolation**: Each tenant's data is separated by a specific column value (tenant_id). This is the recommended method for true multi-tenancy. 2️⃣ **Schema-per-Tenant**: Each tenant has its own schema and tables. While this approach offers isolation, it shares resources. 3️⃣ **Database-per-Tenant**: Each tenant gets a dedicated logical...
Source: PlanetScale Blog
Simeon Griggs
2026-04-10 00:00
🚀 Keeping your Postgres queue healthy is essential for optimal database performance. High-churn job queues can lead to dead tuples if not monitored properly. 🔍 Postgres efficiently handles queue workloads, but it's crucial to manage cleanup processes to avoid degrading performance, especially with mixed workloads. 📊 A well-structured queue table allows for seamless job tracking and management, ensuring that transactions stay in sync. For more insights on maintaining healthy queues in...
Source: PlanetScale Blog
Simeon Griggs
2026-04-02 00:00
Introducing Database Traffic Control™ for Postgres! 🚦 This tool helps manage resource budgets for different traffic slices, ensuring critical operations, like checkout processes, remain unaffected by heavy queries. The article provides practical patterns in Go to implement this, highlighting the use of SQLCommenter format for tagging queries. Key strategies include service isolation through unique connection strings and route-level tagging in HTTP services. Explore how to enhance your...
Source: PlanetScale Blog
Josh Brown
2026-03-31 00:00
In the article "Graceful Degradation in Postgres," the focus is on managing database traffic effectively. When databases face high traffic, critical queries must be prioritized to maintain functionality. PlanetScale's Traffic Control addresses this by introducing resource budgets that protect essential queries during surges. ⚙️ The article outlines how to categorize traffic into three tiers: critical, important, and best-effort. This allows teams to determine which queries can be temporarily...
Source: PlanetScale Blog
Ben Dicken
2026-03-30 00:00
High memory usage in PlanetScale Postgres can actually indicate a healthy system. 📊 While a dashboard may show 80% memory usage, this doesn't mean there’s a problem. Unlike CPU, high memory usage helps keep data close to the CPU for faster access. 🖥️ Postgres uses two caching layers: its own shared_buffers and the OS page cache, both designed to minimize disk reads. Effective caching leads to better performance. For further insights, check out the documentation on normal operating ranges for...
Source: PlanetScale Blog
Simeon Griggs
2026-03-26 00:00
🚀 Exciting news for developers! PlanetScale is now a co-design partner for Stripe Projects. Stripe Projects allows you to provision and manage MySQL and Postgres databases directly from the Stripe CLI. This new tool centralizes the workflow, making it easier to discover, provision, and pay for developer tools without switching between multiple dashboards. To get started, install the Stripe CLI, add the Projects plugin, and follow simple prompts to set up your database. Join the developer...
Source: PlanetScale Blog
Elom Gomez
2026-03-24 00:00
🚀 Exciting news for Postgres users! The recent enhancements to Postgres Query Insights now allow for improved query tagging. Tags can now be viewed in aggregated query data, enabling better insights into query patterns and database performance. 🗂️ You can now: - See tag distributions for query patterns - Search queries by tags - View database-level stats per tag This update helps in answering key questions regarding query execution and performance. For more details, check out the blog post!...
Source: PlanetScale Blog
Rafer Hazen
2026-03-23 16:00
🚦 Exciting news from PlanetScale! They introduced Database Traffic Control™, a feature aimed at preventing database overload from costly SQL queries. This post dives into how it works with Postgres. Traffic Control uses existing extensions and hooks to monitor resource usage and determine whether to allow query execution based on set rules. Learn more by checking the blog post and documentation! 📚 #DatabaseManagement #Postgres #TrafficControl #SQL #PlanetScale
Source: PlanetScale Blog
Patrick Reynolds
2026-03-23 00:00
🚀 Introducing Database Traffic Control™ for Postgres! This new feature from PlanetScale allows you to manage query traffic in real time, protecting your database from unexpected load spikes. Set budgets for different query types based on patterns, application names, and user tags. Switch between warn and enforce modes to keep performance stable. Available now for all PlanetScale Postgres databases, it streamlines incident response and prioritizes traffic effectively. #DatabaseManagement...
Source: PlanetScale Blog
Sam Lambert
2026-03-13 00:00
🌐 PgBouncer is essential for managing Postgres connections efficiently. It addresses the limitations of Postgres’s process-per-connection model, allowing thousands of clients to connect without overwhelming resources. 🔄 By maintaining a pool of reusable connections, PgBouncer optimizes performance, reducing the overhead of multiple connections. It's recommended to use it for all application traffic, reserving direct connections for administrative tasks. 📊 PlanetScale simplifies PgBouncer...
Source: PlanetScale Blog
Ben Dicken
2026-03-03 00:00
🚀 Exciting news in the tech world! The Drizzle team is joining PlanetScale to enhance database tools for JavaScript and TypeScript. Their ORM has gained popularity due to its focus on performance and developer experience, aligning perfectly with PlanetScale's goals. Drizzle will remain an independent open source project, ensuring it stays true to its roadmap. Thank you, Drizzle team, for your contributions! 🙌 #Drizzle #PlanetScale #OpenSource #JavaScript #DatabaseTools
Source: PlanetScale Blog
Sam Lambert
2026-02-27 00:00
🚀 SpacetimeDB recently showcased the world’s first video call over a database! The setup uses PostgreSQL on PlanetScale, capturing audio and video from browsers. It encodes and streams these through a database as real-time messages. The implementation is open-sourced and features logical replication for efficient data streaming. Explore the tech behind it! 🎥💻 #VideoConferencing #PostgreSQL #OpenSource #TechInnovation
Source: PlanetScale Blog
Nick Van Wiggeren
2026-02-19 00:00
🌐 Cloudflare recently launched Hyperdrive, enhancing PlanetScale Postgres connections for faster, real-time applications. With automated pooling and efficient queries, this integration simplifies database connections and leverages the Cloudflare global network for optimal performance. 🌍 Hyperdrive minimizes connection latency and supports WebSockets for real-time updates. Explore the potential for high-performance apps without complex configurations. #Cloudflare #PlanetScale #WebDevelopment...
Source: PlanetScale Blog
Simeon Griggs
2026-01-29 00:00
🚀 Introducing the PlanetScale MCP server! This new tool connects AI applications like Claude and Cursor directly to your PlanetScale database. It enhances schema optimization, query debugging, and app performance monitoring. Key features include: - Configurable access permissions - Built-in safeguards for query execution - Tools for insights, organization, and database management 🔍 Explore how the MCP server can improve your database experience. #PlanetScale #DatabaseManagement #AITools...
Source: PlanetScale Blog
Mike Coutermarsh
2026-01-14 00:00
🔍 Database transactions are key to SQL operations. They allow multiple actions—like reading, updating, and deleting data—to be performed as a single unit. In SQL, transactions start with `BEGIN;` and end with `COMMIT;`. If issues arise, you can use `ROLLBACK;` to revert changes. This ensures data integrity, even in unexpected situations like power outages. ⚡ Both MySQL and Postgres manage these transactions differently, with Postgres using multi-versioning and MySQL employing an undo log to...
Source: PlanetScale Blog
2026-01-07 00:00
🌟 PlanetScale is enhancing its workflow with Cursor commands to automate changelog entries. Each time they ship a feature, a markdown file is created and merged into their GitHub repository, ensuring updates are published promptly. Cursor simplifies this process by generating changelog entries from existing documentation, making it efficient and repeatable. Additionally, these commands can be launched directly from Slack, streamlining the pull request process. #Automation #Changelog...
Source: PlanetScale Blog
2025-12-17 00:00
🚀 Postgres 18 is now available on PlanetScale! When creating a new database, version 18.1 is the default, with options to select earlier versions. Recent offerings include $5 single-node databases and $50 Metal databases. Key updates in Postgres 18 include: - Improved query performance with a new asynchronous I/O system. - Built-in support for UUIDv7. - Enhanced multi-column index usage with Skip Scan optimization. To upgrade from Postgres 17, create a new database and follow the online...
Source: PlanetScale Blog
2025-12-16 00:00
🚀 Exciting news for data professionals! PlanetScale now supports the pg_duckdb extension for Postgres, enhancing analytics capabilities with DuckDB. 🔗 This integration allows seamless OLTP and OLAP queries, simplifying data movement between formats. Users can offload heavy analytics queries to MotherDuck’s cloud, ensuring optimal application performance. 📈 For setup, enable pg_duckdb in your database, grant necessary permissions, and add your MotherDuck token. Check the documentation for...
Source: PlanetScale Blog
2025-12-15 00:00
🚀 PlanetScale Metal for Postgres is now available at a new starting price of $50/month! This update introduces smaller sizes, starting from 1GiB of RAM, and offers eight storage options ranging from 10GB to 1.2TB. With improved flexibility, customers can decouple CPU and RAM from storage, allowing for optimized database performance tailored to specific workloads. Support for GCP is coming soon! #PlanetScale #Postgres #Database #CloudComputing #TechUpdates
Source: PlanetScale Blog
2025-11-21 00:00
🚀 Exciting news for PostgreSQL users! PlanetScale Insights now offers AI-powered index suggestions to enhance database performance. This feature analyzes your database workload and recommends new indexes to optimize query execution speed. By leveraging large language models (LLMs), the system identifies the best indexes while ensuring suggestions are validated for effectiveness. The process involves filtering query patterns and validating suggestions to guarantee substantial performance...
Source: PlanetScale Blog
2025-11-14 09:00
🚀 Exciting news from PlanetScale! You can now create single node Postgres databases for just $5/month. These databases are production-ready and ideal for startups, side projects, and development. PlanetScale offers features like Query Insights and schema recommendations, enhancing your development experience. Additionally, the price for development branches has dropped to $5/month. As your needs grow, you can easily scale your database or switch to high availability mode. Start your journey...
Source: PlanetScale Blog
2025-11-04 00:00
🚀 Announcing Vitess 23! The latest version, 23.0.0, is now available, enhancing deployment and observability for MySQL workloads. Key updates include moving to MySQL 8.4 as the default version, improved metrics for better insights, and simplified monitoring through deprecations. Important upgrade notes for operators: ensure to follow specific steps when transitioning from MySQL 8.0 to 8.4. Explore the improvements and continue scaling with confidence! #Vitess23 #MySQL #DatabaseManagement...
Source: PlanetScale Blog
2025-11-03 08:00
🚀 Exciting news from PlanetScale! They are introducing a new entry point for Metal's performance at just $50/month. This will make high-quality database performance more accessible to startups. Customers can soon allocate CPU and Memory independently from storage size, enhancing flexibility. The new M-class clusters will be available in AWS and GCP, offering impressive performance with unlimited I/O. Sign up to be notified about the upcoming smaller sizes! #PlanetScale #DatabasePerformance...
Source: PlanetScale Blog
2025-11-03 00:00
On October 20, 2025, PlanetScale experienced a significant incident due to a DNS misconfiguration from a service provider. This led to two phases of disruptions affecting their control plane and some database branches in AWS us-east-1. During Phase 1, engineers noticed control plane issues, but customer databases remained operational. Phase 2 saw resource exhaustion, preventing new EC2 instance launches, impacting autoscaling for key customers. PlanetScale implemented measures to mitigate the...
Source: PlanetScale Blog
2025-10-30 09:00
🚀 Exciting news from PlanetScale! They are introducing a new $5 plan, making their quality database services more accessible. The new PS-5 option offers a single node, non-HA mode, ideal for development and testing, without the cost of a multi-node setup. This change allows builders to scale efficiently as their needs grow, reducing migration stress during rapid growth. 🔗 Sign up for notifications on the single node release! #PlanetScale #Database #TechUpdates #Startup #CloudComputing
Source: PlanetScale Blog
2025-10-14 00:00
🚀 Postgres 18 has arrived, showcasing major enhancements in read performance with async I/O and new I/O worker threads. The new io_method option allows users to control disk I/O behavior, introducing worker and io_uring modes. These aim to optimize performance, particularly for read operations. Benchmark tests using sysbench focused on read-only scenarios across various EC2 configurations. Results show that Postgres 18 in sync and worker modes outperformed version 17 on network-attached...
Source: PlanetScale Blog
2025-10-01 00:00
🚀 A new hybrid design for scalable vector indexes is making waves in relational databases like MySQL. This innovative approach addresses the challenges of indexing multi-dimensional vectors for real-world applications. Existing research often overlooks the practical needs of relational databases, particularly in terms of storage and transactional requirements. The solution incorporates a well-known data structure, Hierarchical Navigable Small Worlds (HNSW), that enhances approximate nearest...
Source: PlanetScale Blog
2025-09-24 09:00
🚀 Exciting news! PlanetScale has partnered with Cloudflare to simplify the setup of full-stack applications using Postgres and MySQL. With our new native integration, you can quickly connect PlanetScale databases to Cloudflare Workers, enhancing performance and reliability. Key benefits include: - Faster setup with just a few clicks - Optimized performance through connection pooling and caching - Reduced latency via intelligent edge caching This integration is available for both Postgres and...
Source: PlanetScale Blog
2025-09-24 00:00
🚀 Understanding Processes and Threads is vital for grasping how operating systems function. This interactive article breaks down these key concepts and their role in database performance. 🖥️ Processes serve as the foundation for software execution, allowing multitasking on your computer. CPU and RAM are the primary components that work together to execute code and manage data. 📊 The article also explores instruction sets, explaining how CPUs process commands. Furthermore, it highlights the...
Source: PlanetScale Blog
2025-09-22 00:00
🚀 PlanetScale for Postgres is now generally available! To create a Postgres database, simply log into your PlanetScale account and select Postgres. If you're migrating from another provider, check out the available migration guides or contact the sales team for assistance. Hundreds of companies are already using PlanetScale for their production workloads, with success stories highlighting their experiences. Learn more about our Postgres sharding solution, Neki, which is designed to handle...
Source: PlanetScale Blog
2025-09-12 00:00
Postgres High Availability can face challenges with Change Data Capture (CDC). The design of Postgres’ replication introduces complexities that may stall failover. The primary system emits Write Ahead Logs (WAL) to standbys. However, if a CDC client lags, it can prevent effective failover, as the logical replication slot on the primary depends on the client's progress. Postgres 17 introduced logical replication failover, but eligibility for promotion has specific requirements. If the CDC...
Source: PlanetScale Blog
2025-08-11 00:00
🚀 Exciting news in the database world! Today, the team behind Vitess announced Neki, a new sharded Postgres solution. Neki aims to bring the power of explicit sharding to Postgres users, leveraging insights from extensive experience with Vitess. This initiative is not a fork of Vitess but a fresh architecture designed to handle demanding workloads effectively. Stay updated on Neki's development by signing up at neki.dev! #Neki #Postgres #Databases #OpenSource #Vitess
Source: PlanetScale Blog