COPY exists, and is very fast.
In my experience, DELETE is quite fast when you:
1. have a supporting index, and
2. don't try to delete too much in one statement.
Those are the only PG comments that I needed to archive a 6TB DB down to
2TB.
On Sun, Jan 12, 2025 at 3:42 PM kasem adel <kasemadel8(at)gmail(dot)com> wrote:
> Dears ,
>
> Appreciate your support I have 2.4 TB database and I need to implement
> archiving solutions to prevent data growthing.
>
> Thanks
>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!