Generic Query Plans | Performance in CockroachDB

Description

Want to make your queries faster? In CockroachDB 25.2, Generic Query Plans are now GA. Generic Query Plans optimize query execution by reusing precompiled query plans, significantly reducing the CPU overhead associated with parsing and planning repeated queries. Generic Query Plans also address PostgreSQL compatibility issues. 00:00 What are generic query plans? 00:20 What type of queries can be cached? 00:57 plan_cache_mode explained 01:32 Demo: How generic query plans can help 04:15 When should you use generic query plans? About Cockroach Labs: Cockroach Labs is a pioneering software company at the forefront of database technology, dedicated to delivering resilient and scalable database solutions to run mission-critical workloads for the world's most important businesses. With a mission to scale when others fail, Cockroach Labs is revolutionizing the way businesses manage their data with its innovative cloud native distributed SQL database, CockroachDB.