Re: Archiving solutions

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

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@xxxxxxxxx> 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!