Huge database, archive system.

From: Pär Mattsson <par(dot)x(dot)mattsson(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Huge database, archive system.
Date: 2025-10-27 17:09:30
Message-ID: CAE9Bupyf+8R8i6Kxi5sSWVN8BzfnuymQ1s964FBRVMdQZaKmTQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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!

Br Pär

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-10-27 18:01:32 Re: Huge database, archive system.
Previous Message Pär Mattsson 2025-10-24 12:36:46 Re: PGbackrest very slow!