You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Viraj Jasani (Jira)" <ji...@apache.org> on 2025/10/03 01:14:00 UTC

[jira] [Updated] (PHOENIX-6785) Sequence Performance Optimizations

     [ https://issues.apache.org/jira/browse/PHOENIX-6785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Viraj Jasani updated PHOENIX-6785:
----------------------------------
    Fix Version/s: 5.4.0
                       (was: 5.3.0)

> Sequence Performance Optimizations
> ----------------------------------
>
>                 Key: PHOENIX-6785
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6785
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Geoffrey Jacoby
>            Assignee: Andrew Kyle Purtell
>            Priority: Major
>             Fix For: 5.4.0
>
>         Attachments: Sequence Architecture and Perf Improvements.pdf
>
>
> 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], [~jisaac] and [~tkhurana], 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. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)