Request a Demo
Home   >   mailing lists

Re: Huge database, archive system. - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Huge database, archive system.
Date
Msg-id CANzqJaCayJNQTsdpWDUXng2G3d40Xnv0axsJgWS21Gn7jBrmww@mail.gmail.com
Whole thread Raw
In response to Huge database, archive system.  (Pär Mattsson <par.x.mattsson@gmail.com>)
List pgsql-admin
Tree view
On Mon, Oct 27, 2025 at 1:09 PM Pär Mattsson <par.x.mattsson@gmail.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!

pgsql-admin by date:

Previous
From: Pär Mattsson
Date:
Subject: Huge database, archive system.
Next
From: Ishan Arunkumar Joshi
Date:
Subject: RE: does BUG #18942 and BUG #18938 solution available in Pg16 latest release 16.10