public inbox for [email protected]  
help / color / mirror / Atom feed
From: Pär Mattsson <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Huge database, archive system.
Date: Mon, 27 Oct 2025 18:09:30 +0100
Message-ID: <CAE9Bupyf+8R8i6Kxi5sSWVN8BzfnuymQ1s964FBRVMdQZaKmTQ@mail.gmail.com> (raw)

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


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Huge database, archive system.
  In-Reply-To: <CAE9Bupyf+8R8i6Kxi5sSWVN8BzfnuymQ1s964FBRVMdQZaKmTQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox