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 1u2DEr-00Elzb-WC for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 17:59:58 +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 1u2DEq-00DTVi-Ct for pgsql-general@arkaria.postgresql.org; Tue, 08 Apr 2025 17:59:56 +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 1u2DEq-00DTV5-0k for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 17:59:56 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u2DEo-004BMb-0h for pgsql-general@lists.postgresql.org; Tue, 08 Apr 2025 17:59:55 +0000 Content-Type: multipart/alternative; boundary="------------rg9atIukK1D8Lv7FccMmD1e4" Message-ID: <31c8a0c0-ac43-4b11-a0fd-d038fcce3abe@cloud.gatewaynet.com> Date: Tue, 8 Apr 2025 20:59:52 +0300 MIME-Version: 1.0 Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm To: Amitabh Kant Cc: "pgsql-general@lists.postgresql.org" References: Content-Language: en-US From: Achilleas Mantzios In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------rg9atIukK1D8Lv7FccMmD1e4 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 8/4/25 20:37, Amitabh Kant wrote: > On Tue, Apr 8, 2025 at 9:40 PM Achilleas Mantzios - cloud > 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? > > Amitabh --------------rg9atIukK1D8Lv7FccMmD1e4 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

On 8/4/25 20:37, Amitabh Kant wrote:

On Tue, Apr 8, 2025 at 9:40 PM Achilleas 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>

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?

Amitabh

--------------rg9atIukK1D8Lv7FccMmD1e4--