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 1u2Ctp-00EgNg-78 for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 17:38:13 +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 1u2Ctn-00D7yY-M4 for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 17:38:11 +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 1u2Ctn-00D7yP-B2 for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 17:38:11 +0000 Received: from mail-ed1-x52f.google.com ([2a00:1450:4864:20::52f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2Ctl-004BAY-1X for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 17:38:11 +0000 Received: by mail-ed1-x52f.google.com with SMTP id 4fb4d7f45d1cf-5e686d39ba2so10659047a12.2 for ; Tue, 08 Apr 2025 10:38:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744133888; x=1744738688; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=D7nPu7E8ZZ+NkZ5If3fHDk2Z0JhFRZvoDwRoj64oiVE=; b=hsUt+wD5uNyozcZCs0U92LF0VUM5sDCJqXUIp3PpLxx1yI2SKzxs0WkJShsJ4ZuAtp SRjpQ3GzVUaDM2vWCa+YhpQ8FvNFAzWT+3A2mpcoqoclU7tuvj52byrq2V+iJ41Uj7ft E1d49BeBetRJWvLAl6S+AqvY5HwtTkGxLCODcGe8mDt1AqwMJ7t93kP2Q3w9g2HLqQMd SSXvLFrdKaYb2B0BptD0f/5/FHzcVxhVqqbEF99L8VwzXHJ/qeCwgT2gWbVNeL8ehtgE hlJmsOkP/y0h7tBW4+/rxgtRDBaRIa7GqtVfyKPRk1dq6BZJXumAlHFDj+sSIF8bg74z IssQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744133888; x=1744738688; h=cc: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=D7nPu7E8ZZ+NkZ5If3fHDk2Z0JhFRZvoDwRoj64oiVE=; b=QuqPr7J8kpJHuIw3eoM2sKdYsjatfAq7LGMQ+rc/Hg5JqLVNUBCAG9eOvuh1HwXrzj Z9UulK3l4dOzSSjiM7AdRRKUEGqM7ABu3qHT0pGHKRYElhHx5j7vwSN1oYai6MVqdnmk trEtuYFrdYhyntvr2Wh+uKjApMZELdn/PY6hB0a8Gqmciipg6QSjTjuAW+qh1tT5dgWZ +rxE962LCTehwP4jWrNODZKrbVfMMHe4uL1BX0Wy2wAOXyPSyf+F+mBGTJ9hHUyitXsK JNSTLRAAVmk2QurpPR5Kbr/6YCz9TFQH7L7J3qPtoYIas/vLqrN06FJo+BIq2xXnxBso IAoQ== X-Gm-Message-State: AOJu0YwEdq3cMRdeeWxF7BOmWZCz3DDf/n3ChfMDxzQb7LmOAs5IsmU7 1WR0HOpoBngzcLIGBps5PGTMZ4mZlw6CVDUMfpwJGss9gjFOP+pTZRLGnx4SmOdk0vx4oh1Qr1q tUO3RIc/5bAkYXnW33olQrv+T9jtG22p6 X-Gm-Gg: ASbGncvOq1zdS3SQD+HLSTNW0n5jxeRMUfhYUeocVXS+QqJ/XZ476bi3tvcTpucs/6T J/g4v2aHJlwAZD8HTIScfwePwDbD2z1yPPz56jsNzgquyaybUvDaJDh4X4loWcuKWtHASFkky8A iI7JkuL3o0o9xe6gfzoeBEckhhXgdGeSWF1++vPNZWqWqUpxk9NJuuQrjhl10H X-Google-Smtp-Source: AGHT+IE48dJOGNwfPFJx87DogpU1ytTsE7jxP3vBxT6vbmfqPA7rNdu3ghEXdx+06etvaTzzgUmIt+cSUuZ3r6d1xmE= X-Received: by 2002:a05:6402:501a:b0:5ec:7909:1a with SMTP id 4fb4d7f45d1cf-5f0b3b90213mr15600095a12.12.1744133888338; Tue, 08 Apr 2025 10:38:08 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amitabh Kant Date: Tue, 8 Apr 2025 23:07:32 +0530 X-Gm-Features: ATxdqUGIXQh5SKk8YcmZHpaBIpihzViRlTKV1J3rRHGB_ndP4f-DRFG8JpqLc68 Message-ID: Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm To: Achilleas Mantzios - cloud Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000daf0b7063247d051" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000daf0b7063247d051 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Apr 8, 2025 at 9:40=E2=80=AFPM Achilleas Mantzios - cloud < a.mantzios@cloud.gatewaynet.com> wrote: > Hi > > timescaledb seemed mature, but also exotic, allow me the term. No way to > use native logical replication, shortage of options to run on premise or > self hosted, which leaves us with those options : > > > > I cannot comment on the applicability of timescaledb in your context, but running it on premise/self-hosted has posed no problems, at least on Debian. If I understood your query incorrectly, please ignore. Amitabh --000000000000daf0b7063247d051 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Apr 8, 2025 at 9:40=E2=80=AFPM Ac= hilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com> wrote:
Hi
<snip>
timescaledb seemed mature, but also exotic, allow me the term. No way to use native logical replication, shortage of options to run on premise or self hosted, which leaves us with those options :

<snip>

=C2=A0
I cannot comment= on the applicability of timescaledb in your context, but running it on pre= mise/self-hosted has posed no problems, at least on Debian.=C2=A0

If I understood your query incorrectly, please ignore.

Amitabh
--000000000000daf0b7063247d051--