You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@atlas.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2025/09/29 06:07:00 UTC

[jira] [Commented] (ATLAS-5140) Postgres backend: cache sequences to improve performance

    [ https://issues.apache.org/jira/browse/ATLAS-5140?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18023481#comment-18023481 ] 

ASF subversion and git services commented on ATLAS-5140:
--------------------------------------------------------

Commit 9afdcfe2b85702592276b1ee72fde426c1f446f5 in atlas's branch refs/heads/master from Madhan Neethiraj
[ https://gitbox.apache.org/repos/asf?p=atlas.git;h=9afdcfe2b ]

ATLAS-5140: updated Postgres sequences to cache 1000 numbers for faster access (#454)



> Postgres backend: cache sequences to improve performance
> --------------------------------------------------------
>
>                 Key: ATLAS-5140
>                 URL: https://issues.apache.org/jira/browse/ATLAS-5140
>             Project: Atlas
>          Issue Type: Improvement
>          Components:  atlas-core
>            Reporter: Madhan Neethiraj
>            Assignee: Madhan Neethiraj
>            Priority: Major
>          Time Spent: 1.5h
>  Remaining Estimate: 0h
>
> Setting up Postgres sequences to preallocate several numbers in memory can improve the performance of insert operations in Atlas. Currently, each insert allocates the next sequence number, which can result in slower insert operation. For more details, refer to https://www.postgresql.org/docs/current/sql-createsequence.html.



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