yugabyte-db icon indicating copy to clipboard operation
yugabyte-db copied to clipboard

[YSQL] Auto-analyze incremental catalog cache refresh

Open yifanguan opened this issue 4 months ago • 0 comments

Jira Link: DB-13415

Description

This is one item to keep track of incremental catalog cache refresh for auto analyze. Incremental catalog cache refresh is a general optimization. It benefits a large range of SQL DDL by saving the overhead of reloading PG cache on all PG backends. Auto analyze service runs ANALYZE commands which increment catalog version.

Issue Type

kind/enhancement

Warning: Please confirm that this issue does not contain any sensitive information

  • [X] I confirm this issue does not contain any sensitive information.

yifanguan avatar Oct 17 '24 21:10 yifanguan