Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vDRXS-008zui-8W for pgsql-admin@arkaria.postgresql.org; Mon, 27 Oct 2025 18:01:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vDRXR-008dxs-3f for pgsql-admin@arkaria.postgresql.org; Mon, 27 Oct 2025 18:01:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vDRXQ-008dxk-Ol for pgsql-admin@lists.postgresql.org; Mon, 27 Oct 2025 18:01:47 +0000 Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vDRXN-004Yla-2Y for pgsql-admin@postgresql.org; Mon, 27 Oct 2025 18:01:47 +0000 Received: by mail-oo1-xc29.google.com with SMTP id 006d021491bc7-64e5f669511so2492681eaf.2 for ; Mon, 27 Oct 2025 11:01:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761588104; x=1762192904; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=V8pN8m68xSzXBucU4PZS9G6wR+sVgmiAWJAn10gj+uY=; b=dj+KvAY8N1WMa2hkxsKObHrGFy5NwuTe7RnK7maXxyzekOwKGh5SU7ZZZt86LywdAk InsRw3GBLDy/cd9sm1KnX9WeNiUd1L+AhKEGatVpnQpl//t2tCHzUZwQh4mPxQW3jAkY rDW4EdrlJIrbNNkz1wN7L0U7BxGA/6xz/rfFra8qgHtXkajd+V+KaeyuoOn3YOtJEDwS jFFeNYaThTEF553ctEniv3IXwe5z4SAAxd1Z3cxppMiyRBzbIxOH2hiKdAL6WlAx5UOh KYVo8ChH/3jI4IsZ06zyRsg6/JS2RkJQpM1rWbojtYf8ZzgcovgFCp0iJnvJf5IO+e0O 5ksg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761588104; x=1762192904; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=V8pN8m68xSzXBucU4PZS9G6wR+sVgmiAWJAn10gj+uY=; b=aUz19AcObBNdjD9Y6/hAApJkbDM9CO0lacYfNQs0BkKkhYSFWMR8baHz8IZLTzhiOb 8141UixtWW4mmwpk3N2RKHtlP9k90680PItJqta5QIdXgxyrl4u8WzixL9YoY7GiuaeA ZkrFGPBrmfeLH4R9EPe9yfh5Jiy3pqScKv3cx0rZ7a3hcSrvh278DDPEuKt+AEFzjKMN BhgXLHdC9DsUIQuwIRVwavyX9dxZ+9svJdima4j2bmLII8jtl/mwq6g0em6KQBOZh2Xe zsk7ls8gGovcADoc+5xFL/Gut6pg19l5H80JCFm8A6rUcK57RmqYoL1o4xpj9meG+5Gn Ta5w== X-Gm-Message-State: AOJu0YxtTVtpICP6APuAQVjL+GBAE+9KECWuiPzwSROz91KUY7iUz1gm nCFVyRNx/6tDeDaOihfW6dfJVU7SPPK/ToPfO7by9epOqR7bLLE0lFg19B+i2Ru1huvrUgCDtHz 8PtppSSg4y2KB1GGcmTcKylH67kszO1EqkQ== X-Gm-Gg: ASbGncv15I6Ab711QYgdLmC7cY9rI/oE3dVb5f1pBqv2O8cwx+k2JNjy0DjSfSrzVuo mnJLFTBsGPsWieTz70N4qFnjcYaEiUpHuzTob3Do8Qu5u2jc4W+NCU4GD4nNEMUYlbIwN2n4ohS VCLvFoil43JYEhy7RG84GJafiSTBrBsBtjvEeOE2esV60r80oi1fgBV9aa+VKxPGISmfEAzEeRT 41mFrq1zKSoD1t5ASLPGe7b0orH76CvQNiysGitCaeNbW/nveY3lN4Md4tNZA== X-Google-Smtp-Source: AGHT+IE/1ps4k+uoNg1JI35o8tBmmyFVs1sXR67uJDEc7DLThdhNM7JSKPZjCj10D2x430viEZyHutgk35Uau9Fh0Kw= X-Received: by 2002:a05:6820:3091:b0:64e:611e:b7c4 with SMTP id 006d021491bc7-6566f1a4a99mr372463eaf.2.1761588103562; Mon, 27 Oct 2025 11:01:43 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 27 Oct 2025 14:01:32 -0400 X-Gm-Features: AWmQ_blLSRamQZjvYfndQfOFkbHsojO8i0B4BIv3mRppa8L-qhzE68BoV8shuIE Message-ID: Subject: Re: Huge database, archive system. To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000274a12064227b1cb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000274a12064227b1cb Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Oct 27, 2025 at 1:09=E2=80=AFPM P=C3=A4r Mattsson 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 , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000274a12064227b1cb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Oct 27, 2025 at 1:09=E2=80=AFPM P= =C3=A4r Mattsson <par.x.matt= sson@gmail.com> wrote:
Hi=C2=A0
I got a project in the postgres area.
<= div>
We will create an archive database.

=
The volume is 30 GB every day.

1TB every=C2= =A0month

Savetime 5 years so total 6= 0 TB.

Backup will be a challange!

Partitioning = table is our thoughts.

Hit me with your opinions!

Not nearly enough infor= mation.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'= ;m still alive.
<Redacted> lobster!
--000000000000274a12064227b1cb--