Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[YSQL] Consider pre-creating the sequences namespace and table #4921

Open
m-iancu opened this issue Jun 30, 2020 · 0 comments
Open

[YSQL] Consider pre-creating the sequences namespace and table #4921

m-iancu opened this issue Jun 30, 2020 · 0 comments
Assignees
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/low Low priority
Projects

Comments

@m-iancu
Copy link
Contributor

m-iancu commented Jun 30, 2020

Jira Link: DB-1330
As mentioned in #4890 the metadata for sequences (last val, is_called, etc) is stored in a dedicated system table (sequences_data) that is created (along with its namespace system_postgres if needed) the first time a sequence of created.
As a follow-up to #4890 we should consider pre-creating these when initializing the cluster in the future to improve reliability and usability (e.g. avoid further issues with concurrent create sequence, or the first create sequence taking longer than expected).

cc @hectorgcr

@m-iancu m-iancu added the area/ysql Yugabyte SQL (YSQL) label Jun 30, 2020
@m-iancu m-iancu added this to To do in YSQL via automation Jun 30, 2020
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Sep 18, 2022
@yugabyte-ci yugabyte-ci added priority/low Low priority and removed priority/medium Medium priority issue labels Oct 25, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/low Low priority
Projects
Status: No status
YSQL
  
To do
Development

No branches or pull requests

3 participants