Обсуждение: Huge database, archive system.

Поиск
Список
Период
Сортировка

Huge database, archive system.

От
Pär Mattsson
Дата:
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

Re: Huge database, archive system.

От
Ron Johnson
Дата:
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!