[PHOENIX-6785] Sequence Performance Optimizations - ASF JIRA

Attach files

Attach Screenshot

Add vote

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: 5.3.0
Component/s: None
Labels:
None

Description

We've encountered scaling issues with Phoenix sequences in our production environment, particularly with heavy usage of the same sequence causing hotspotting on the physical SYSTEM.SEQUENCE table.

After some informal discussions on this with Kadir Ozdemir, Jacob Isaac and Tanuj Khurana, I wrote up some thoughts on improvements that could be made to sequences in a future Phoenix release. I'll attach it to this JIRA.

As there are several proposed improvements, this will be an umbrella JIRA to hold several subtasks.

Attachments

Sequence Architecture and Perf Improvements.pdf
08/Sep/22 20:49
90 kB
Geoffrey Jacoby

Sub-Tasks

Create Sub-Task

1.	SequenceRegionObserver should use batch mutation coproc hooks	In Progress	Andrew Kyle Purtell	Actions
2.	Server-side Sequence Update Consolidation	Open	Andrew Kyle Purtell	Actions
3.	Client-side Sequence Update Consolidation	Open	Unassigned	Actions