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 1u2KbL-00GRwo-P8 for pgsql-general@arkaria.postgresql.org; Wed, 09 Apr 2025 01:51:39 +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 1u2KbI-00HBAn-SM for pgsql-general@arkaria.postgresql.org; Wed, 09 Apr 2025 01:51:37 +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 1u2KbI-00HBAf-I3 for pgsql-general@lists.postgresql.org; Wed, 09 Apr 2025 01:51:36 +0000 Received: from mail-ed1-x52b.google.com ([2a00:1450:4864:20::52b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2KbH-003mm3-0f for pgsql-general@lists.postgresql.org; Wed, 09 Apr 2025 01:51:35 +0000 Received: by mail-ed1-x52b.google.com with SMTP id 4fb4d7f45d1cf-5e66407963fso11913238a12.2 for ; Tue, 08 Apr 2025 18:51:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744163493; x=1744768293; 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=dMHbjlCywo0/GpfopVK4xv6nr/IhvP1Qam8nx7YLUzE=; b=l5cMn0AuWjhOKHbmjULomE/GNBd2wgtbslTvOw8gGTvHddabyTHiPfKL4tpHI+4Vwy pBRNSZJoPsk4KdCL+TqKAci1V2Yl7CriGJnldjazSlTteOS69owQbOiK1yCHvLmRtYHO JcOSCLc9wo+FdsrOm+5vwIw51DZGkz/5okfpAj5pv/Kml9tlUDBw2lG0ZIbMpeXlloRI np9itTPh5dTc4vw+CuAlZyp3/xBMr6yFrlYwKgaEHO15f7ToLaja3vvClqhfCavxZeHt ksZlzOIGaFyzXSprSQ1v0TxUvD9beX6vqawKlAkjgNl2+qFL8YU/wSxMu2jxbqImDNVE ow1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744163493; x=1744768293; 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=dMHbjlCywo0/GpfopVK4xv6nr/IhvP1Qam8nx7YLUzE=; b=XyHd3fA0ue2PkX1krmtn9AU/MLT2zNMWV/u6BdTkklW3a3aDTdKyCw0t/aVifb7Dao tOUwbYbIxdn+AtmqV4xumxMiEVuIDKwNa6z6NEszW8OgoioWP/EH0mQGjZi9zCNYgXRE 3SiA/puXi3wpVWFYRPe2TrVvnvVKIcr/3atiDiqH87YG/2ZKTNiG1LbiND2WTsxWWNFa +5eqM8mryF9HSkrQD6hODcdfDfFB4YuBIoHK9IotSgGlcrxLPiAe/7sddghMohrHBJBW QFzvo9qQfWqzkPWkg8FtEZbxkQKpv+g7Qq8NV84P9duytK/mCOQCkYat10WOT4EM8qDR ne6A== X-Gm-Message-State: AOJu0YyegS/Kf4tV9Dherm53HogykTmTmOkktpU2ZaIepIUtngm/6qWe n2uMeJnWgq41O60rU58Df29LD62RY1kQa90lVf+6j4ngn2Fvm+xpOMyWl96XMto4F+lreaqqAlv pjhLd3gTYwLVD2jKWlFEMhbqJP6I3I1SO X-Gm-Gg: ASbGncvKEiZiXNNPQYyRZ9VepBCOXd0izIeQ+TdxsP6CL0rOBHfh54aEkI5KA9TZ+BA j1UPSETZi7zzUi8TjTEjMI8uUn0X+y+W0VKPAIPeKaq1T24xJhROQG3+OGLFVr6herOUUHODOHq ORgnHlTLoGR9PrqiHR9KDPOwRmgQLXWTFilq/GayMiLAUtSw7CENZZ7T+UE4rL X-Google-Smtp-Source: AGHT+IHh5vdZxBr4Ne9zrYd03hjabyx/m8Vxw9/DPkpahrOOzfxPwJcDhUbyhZBv78Pm2J6k3fHlihdGAscpjuvUA6g= X-Received: by 2002:a05:6402:51d2:b0:5ec:f769:cfa1 with SMTP id 4fb4d7f45d1cf-5f2f7750514mr849786a12.29.1744163492685; Tue, 08 Apr 2025 18:51:32 -0700 (PDT) MIME-Version: 1.0 References: <31c8a0c0-ac43-4b11-a0fd-d038fcce3abe@cloud.gatewaynet.com> In-Reply-To: <31c8a0c0-ac43-4b11-a0fd-d038fcce3abe@cloud.gatewaynet.com> From: Amitabh Kant Date: Wed, 9 Apr 2025 07:20:56 +0530 X-Gm-Features: ATxdqUE9fhusSQ4csZKEg7h0lRGzh4XPJ8iZPYPFkwtgFtwGWkW5nSV313fOeTM Message-ID: Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm To: Achilleas Mantzios Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000696edf06324eb58e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000696edf06324eb58e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tue, Apr 8, 2025 at 11:29=E2=80=AFPM Achilleas Mantzios < a.mantzios@cloud.gatewaynet.com> wrote: > > On 8/4/25 20:37, Amitabh Kant wrote: > > 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. > > Thank you, I meant the paid/supported service not the community version. > Which of the two do you use? > > > I use the community version. --000000000000696edf06324eb58e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Tue, Apr 8, 2025 at 11:29=E2=80=AFPM A= chilleas Mantzios <a.= mantzios@cloud.gatewaynet.com> wrote:
<= u> =20 =20 =20


On 8/4/25 20:37, Amitabh Kant wrote:
=20
On Tue, Apr 8, 2025 at 9:40=E2=80=AFPM Achilleas M= antzios - 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 premise/self-hosted has posed no problems, at least on Debian.=C2=A0

If I understood your query incorrectly, please ignore.
Thank you, I meant the paid/supported service not the community version. Which of the two do you use?

<= br>
I use the community version.=C2=A0=C2=A0
--000000000000696edf06324eb58e--