Re: Huge database, archive system.

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Huge database, archive system.
Date: 2025-10-27 18:01:32
Message-ID: CANzqJaCayJNQTsdpWDUXng2G3d40Xnv0axsJgWS21Gn7jBrmww@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Oct 27, 2025 at 1:09 PM Pär Mattsson <par(dot)x(dot)mattsson(at)gmail(dot)com>
wrote:

> Hi
> I got a project in the postgres area.
>
> We will create an archive database.
>
> The volume is 30 GB every day.
>
> 1TB every month
>
> Savetime 5 years so total 60 TB.
>
> Backup will be a challange!
>
> Partitioning table is our thoughts.
>
> Hit me with your opinions!
>

Not nearly enough information.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ishan Arunkumar Joshi 2025-10-28 10:21:05 RE: does BUG #18942 and BUG #18938 solution available in Pg16 latest release 16.10
Previous Message Pär Mattsson 2025-10-27 17:09:30 Huge database, archive system.