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 1vDQj6-008jhC-Na for pgsql-admin@arkaria.postgresql.org; Mon, 27 Oct 2025 17:09:48 +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 1vDQj5-008RNe-MD for pgsql-admin@arkaria.postgresql.org; Mon, 27 Oct 2025 17:09:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vDQj5-008RNV-Af for pgsql-admin@lists.postgresql.org; Mon, 27 Oct 2025 17:09:46 +0000 Received: from mail-wr1-x42c.google.com ([2a00:1450:4864:20::42c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vDQj2-0043vH-0j for pgsql-admin@postgresql.org; Mon, 27 Oct 2025 17:09:45 +0000 Received: by mail-wr1-x42c.google.com with SMTP id ffacd0b85a97d-42421b1514fso3499295f8f.2 for ; Mon, 27 Oct 2025 10:09:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761584981; x=1762189781; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=WRe79Czk4Y1n4Fkn+r4+dOZa9Esvjz48bSn/lrWL3Bg=; b=WeSsLNckVCCoeAVi3FZcny3A/B2AioJ55SdUvOH6NBZUwq5IRhUHwu9uHQjqv5q3Qv lMf95rCj+p7tbAph4ASTGiBdC5p6L2HBtIq5HDJ0HJPfy3W0hehmOnMJi6ply+JToRrn cBvFL1MtiFHT7ZOr/Np3iJhn4eVwuK7RWo2wLLDZcCetio8TmPUdi93e8Mzxlnn8HboE WBripfVCm6WJs/QfmfATPtgeQMe3LPd2FesGR4XIoxan8jNfysTHo0BG3YZH6JsQppUT pPoVJEiQ//z0YjqWzmsdVsQzbudACeFkshp0IRO37QPHW7SH2Q+UbiLwMVkdESYVCUYX LPOg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761584981; x=1762189781; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=WRe79Czk4Y1n4Fkn+r4+dOZa9Esvjz48bSn/lrWL3Bg=; b=TuOGeQJs7oEVLQZbcnj2SxCfAo9EuSXpdCjIkdzKI0/9CVfFn6DUCzlFW+anw0yuou TR6jHQeci0BtrW5tuSKCE/XySPocHfUmqPDHfWlDQczTUERattOotue+wrpbgYYI+I8v epGm5eJBi/BDYrVXJtsWvhjX5cUcQghLZsQJTSuwHyZ8rjvgvF8gmO8QDM11jStyS8SB g20CP08JzZenhIqt+fkq2Ciq65r+ChmDGpIXY9mqSmYtKqK9iwtQbHasWZQCo0Hsm6ai BVFWXd8N3IN5KDXg9ROG3zvxyQipS10IZ5rxB4MlLsUCjJOzica2ZH8ZLZvBqFaEpmU1 YGfA== X-Gm-Message-State: AOJu0YwlAGrVm8dCY8cHArh92/wX5YDVcjwTcnlHGz+hYE9+AHfBuazz pVnlARaB79B6cmEkXgW3h+1enWCaiDpm5wPwuE1Qwx1nRUKG3EpBsMe2UNGVkHHmUw/N06cbMUn NUTN+Edck6GHQLtnaSWCy4bc+sBbHtDlLufH09Y4= X-Gm-Gg: ASbGncvrxodJOYWXRbA9m9TWIQF8aWMhilmwozXRh1kmrFORAs3yxxsTgF/KxyroJ3H XG5Sv1rUuO3HySiG6K8YJ18U+6XB9aN82dBId7IsgrddhPv2G7KYJraBnhZD/77MBweABods+Z4 4C9UdVa4w5pbdWp3bUranxiolVyOXvpO3TOB3dUGAL+TmtAjXcAosbbHbf3w1LAzUejyT6qyaHG uOkm+oEKbu+w+X3zmujctoV+VmzjgoMTvL2vh2Z6SVN0LGWOO8ir+aE X-Google-Smtp-Source: AGHT+IHQGcUYlI+Zf3E5f/d55aoxxa8nhHWQkLXhk1wLBd7W5q8kk2TTkRClQhZs1QEl/pu2ECNQHSrTN4w7k3+AVdA= X-Received: by 2002:a05:6000:3113:b0:3ec:248f:f86a with SMTP id ffacd0b85a97d-429a7e7d816mr350352f8f.48.1761584981213; Mon, 27 Oct 2025 10:09:41 -0700 (PDT) MIME-Version: 1.0 From: =?UTF-8?Q?P=C3=A4r_Mattsson?= Date: Mon, 27 Oct 2025 18:09:30 +0100 X-Gm-Features: AWmQ_bnJvotPdA4wOO_48T1A7uGS178p2_rXbe5YHR8O35jt2P5so23n9FOnB0c Message-ID: Subject: Huge database, archive system. To: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000000c07de064226f73a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000c07de064226f73a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=C3=A4r --0000000000000c07de064226f73a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0
I got a project in the postg= res area.

We will create an archive database.

The volume is 30 GB every day.

1TB every=C2=A0month

Savetime 5 ye= ars so total 60 TB.

Backup will be a challange!
<= div>
Partitioning table is our thoughts.

Hit me with your opinion= s!

Br P=C3=A4r
--0000000000000c07de064226f73a--