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

From Pär Mattsson
Subject Huge database, archive system.
Date
Msg-id CAE9Bupyf+8R8i6Kxi5sSWVN8BzfnuymQ1s964FBRVMdQZaKmTQ@mail.gmail.com
Whole thread Raw
Responses Re: Huge database, archive system.
List 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

pgsql-admin by date:

Previous
From: Pär Mattsson
Date:
Subject: Re: PGbackrest very slow!
Next
From: Ron Johnson
Date:
Subject: Re: Huge database, archive system.