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.
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.
