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 1t8N5x-003mMP-3c for pgsql-admin@arkaria.postgresql.org; Tue, 05 Nov 2024 17:11:56 +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 1t8N5u-00GG1r-Gi for pgsql-admin@arkaria.postgresql.org; Tue, 05 Nov 2024 17:11:55 +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 1t8N5u-00GG1h-4t for pgsql-admin@lists.postgresql.org; Tue, 05 Nov 2024 17:11:54 +0000 Received: from sm-r-016-dus.org-dns.com ([89.107.70.6]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8N5q-000KnQ-PV for pgsql-admin@lists.postgresql.org; Tue, 05 Nov 2024 17:11:53 +0000 Received: from smarthost-dus.org-dns.com (localhost [127.0.0.1]) by smarthost-dus.org-dns.com (Postfix) with ESMTP id E23BDA04BF for ; Tue, 5 Nov 2024 18:11:48 +0100 (CET) Received: by smarthost-dus.org-dns.com (Postfix, from userid 1001) id D65A7A0961; Tue, 5 Nov 2024 18:11:48 +0100 (CET) X-Spam-Status: No, score=-0.9 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, KAM_INFOUSMEBIZ,RCVD_IN_VALIDITY_RPBL_BLOCKED, RCVD_IN_VALIDITY_SAFE_BLOCKED,SPF_HELO_PASS,SPF_PASS autolearn=no autolearn_force=no version=3.4.6 Received: from ha01s018.org-dns.com (ha01s018.org-dns.com [62.108.32.138]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by smarthost-dus.org-dns.com (Postfix) with ESMTPS id 942CCA04BF for ; Tue, 5 Nov 2024 18:11:42 +0100 (CET) Authentication-Results: ha01s018.org-dns.com; spf=pass (sender IP is 178.197.239.36) smtp.mailfrom=thiemo@gelassene-pferde.biz smtp.helo=dummy.faircode.eu Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated) Date: Tue, 5 Nov 2024 18:11:39 +0100 (GMT+01:00) From: Thiemo Kellner To: pgsql-admin@lists.postgresql.org Message-ID: In-Reply-To: References: Subject: PostgreSQL historical database MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2_109378060.1730826699827" X-Correlation-ID: X-PPP-Message-ID: <173082670218.2049599.12018534725998017410@ha01s018.org-dns.com> X-PPP-Vhost: gelassene-pferde.biz X-POWERED-BY: wint.global - AV:CLEAN SPAM:OK List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_2_109378060.1730826699827 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi I am not sure what the purpose of yours is. To the best of my knowledge, transactions have no validity duration and are immutable such that historicisation use useless. Maybe it would help to know your goals in more detail. Kind regards Thiemo ------=_Part_2_109378060.1730826699827 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi

I am not sure what the purpose of yours is. To the best of my knowledge, transactions have no validity duration and are immutable such that historicisation use useless.

Maybe it would help to know your goals in more detail.

Kind regards

Thiemo
------=_Part_2_109378060.1730826699827--