| From: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Archiving solutions |
| Date: | 2025-01-13 04:33:27 |
| Message-ID: | CAJk5AtaP5vk+5R9SmQ_H+-V9jct09vJxjpN+9Jt1u9zF==3CBQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
What are regular housekeeping activities @Imran?
On Mon, 13 Jan 2025, 07:27 Ron Johnson, <ronljohnsonjr(at)gmail(dot)com> wrote:
> 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!
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Imran Khan | 2025-01-13 04:48:28 | Re: Archiving solutions |
| Previous Message | Ron Johnson | 2025-01-13 01:56:55 | Re: Archiving solutions |