[jira] [Commented] (SENTRY-1949) Old full snapshots are never cleaned up

["Sergio Peña (JIRA)" <ji...@apache.org>]

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

Sergio Peña commented on SENTRY-1949:
-------------------------------------

[~LinaAtAustin] It might be useful if we follow some ideas from this blog about how to delete large number of rows from:

[https://www.brentozar.com/archive/2018/04/how-to-delete-just-some-rows-from-a-really-big-table/]

> Old full snapshots are never cleaned up
> ---------------------------------------
>
>                 Key: SENTRY-1949
>                 URL: https://issues.apache.org/jira/browse/SENTRY-1949
>             Project: Sentry
>          Issue Type: Bug
>          Components: Sentry
>    Affects Versions: 2.0.0
>            Reporter: Alexander Kolbasov
>            Assignee: Na Li
>            Priority: Major
>         Attachments: SENTRY-1949.001.patch, SENTRY-1949.002.patch, SENTRY-1949.003.patch, SENTRY-1949.004.patch, SENTRY-1949.1.patch
>
>
> We never clean old snapshots and they stay forever, hurting performance as more and more are accumulated.
> [~vamsee] FYI.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)