Skip to content

sqlliveness: partition table so that sessions can be created without WAN RPCs #85736

@ajwerner

Description

@ajwerner

Is your feature request related to a problem? Please describe.

The process of creating a new sqlliveness session today involves a single Put operation to the system.sqlliveness table. Proving a record is invalid requires scanning the table. Today, the table has no zone configurations so can be in any region.

Describe the solution you'd like

In order to reduce the server cold-start time, we'd like to change the table to be regional by row so that we perform a write to the table without having to wait for multi-region round-trips.

Additional context

In order to make this happen, we'll need to allow regional-by-row tables in the system database.

Part of #85612

Epic: CRDB-18596

Jira issue: CRDB-18410

Metadata

Metadata

Assignees

Labels

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-foundationsSQL Foundations Team (formerly SQL Schema + SQL Sessions)

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions