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 1u2L6l-00Ga1C-UN for pgsql-general@arkaria.postgresql.org; Wed, 09 Apr 2025 02:24:08 +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 1u2L6k-00HLqA-Bv for pgsql-general@arkaria.postgresql.org; Wed, 09 Apr 2025 02:24:06 +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 1u2L6j-00HLpy-Ud for pgsql-general@lists.postgresql.org; Wed, 09 Apr 2025 02:24:06 +0000 Received: from sonic311-25.consmr.mail.ne1.yahoo.com ([66.163.188.206]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2L6g-004FRm-27 for pgsql-general@lists.postgresql.org; Wed, 09 Apr 2025 02:24:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1744165439; bh=/Bj2hW3LnZUr0JC+FN+cde4KnSz2CNpYmlg76hI9P5U=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=fCVC8XXTz0c+yya3O7VAzJuFk5ygXDcniWX8bVyKpSNFtZ4bXgePnvfCcp7ic2E16FIfdCxZZhbukXuFJrL1NXg5W4uKXmjnATXh6s8Mqdh6aAD5p89/w3KkyNtDJP+t5QcuA+ezAKTdW5qnzOlzoFqQm5eK71QljIA1QOXTW9zmHL71Q2vLauf9sRdtHz8mw7btAGp5eBKxaxWxhha8YJ9MH98xpMKsMUfUIk6TDi1kwchQTlUQryH2H5REK/6yBr31D0ypnUGKwaswgZ/5sLQm+H99ERIwjRuyl1qOlT2FQgAEkD01osPoGdVMo293Q0UqA2Q8zFJC32ogRoF3IA== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1744165439; bh=ukomyAHRpdap+Cxqa6VyWBnggyFyHHlofT4iOgoa7vz=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=hooN9u0WJQipqUkVGvcYOf6vX0IX5bRpjD4JCHn+sw6ddos/0FEbr0zmSdiLDAWJiAx2FAF2mZ2AaYUplNrX+E0b01yIBAxzdpCEbsMTutWNFwKC5mrg48tPgN23B3EDmsT3wMsQrKOOS0jYEOV+mK8K99Q1RN40bvcEaYpfzTwZGHUA6Vt5fvj7EVj/HXWcbQOVCAtVLChL6+hdZx1rqhT/jYNVBc8gbesdGVuLi0wlFP2BhG1oGix06BdeEg+u/mQSWHnE1lSfZxPcxv8K7/cvIKQMwiJ9r8lImzO+FCp5thP3r9UyMtIe6YYyk+6Nx9mGZunwUimkvm/nkerU4w== X-YMail-OSG: 8XpI2UwVM1lhwJj5VO2EvzTSaUuOpZFudGHG7ujg6mAPXXMIEF1.VgtLSDys1Q_ tOFZsO2k2p0Yp.arH2gwd5.2mnbjUeCUEDANmvXd1OPtpsRKpU_K2abb06krIdEp9ySkBTp9aoNh J4pXn6HuJUjtIUY7hfgrhdOeSbknbid0SCfCGvn37XONcdSysdSKQgVh0ybNFDCOqbPVpARoDsvI OW4YlWLA2CNAoxAy.kdRdkxlD4xnVNKRdIGPwQdDQevd478TgEmoytWIUIaFAYMxc3Jv_eOZW76t 9aXWe5dJUn2Kl_FlimLBFbp0KwP035EO7rSE6Nv1nXXbI8zn1P3Jde5APARYtJJPYCx3z_j1Q.5x FrW4ceZ4NwldEQMOWmDEivgYQV56ssZyXJ39hohu70ccoEDcp5QRpUk3Wgrn8Rf2IcvuYC30Wk6c 7lINeopVQ5AMHOKi7KZgpi6.yQTJzSaLfRToCF6GtgL1.PmpIjTqXzXhAjwaP2tWX38RmgYYBpZQ 4S0WBWmyuAezN5dq6OA2EGC.78oBE05HXuXivhJB8TuB07fDi2rUmAJp1jObVWBBkIqL8LlmFtEl RqGSMCgP1idS41.AjPVxjHOYAf19j_7N8o4U_BL5lh2mIUgTk.TpDI5AWuqtK11OtXT9uI8ctq1Z mvrtVRIj8d0xCQOI8HmYiBkxy.Ttcr3qUBTuwKpdVWBXWvuzOBBrt9x9ioSRCQUiDdOcPf9bnldl o4c5svUf6pbAxAochDJZ_W4bVawCe8aoLlucSf24CTIXBkcdMZFVsoHumPtcfgIDFxh_na_8P8hx MZISKpFqAhsifjsBXG20rmd0utYEo_403qUQcpLIiOo.Ybt3P1609oI4Cd26cRTAtZzeajaM6HCs key3LEd7LPhZTaZJInpLPnKxMOM8cU54xOM4MOJXzRENBy2SITtN4Qukog5AnyyFWyReg9c4IoZD BQDqcLVHUcMqTEfnlNshELDvsM3fs8QgiIcXXkk11NE0u8u_DqKueeVN6QsmKcJdBfNjB5Bp0J.V TtB7OKcbnbwKdx5u3Uba.47BiNPA.oFER.vfarD1xPOfxiYZ4X_IOB0FYMpXSfJ2RcAae7dFq9bq Zjp_9hnZ_xdayVb9xceded42mSVW8YkJL.vWw7ZKrDU4sVRYC12_ddlMq.wWo3H8irSVAUJa8_EW LUZSmTc94p8KLU2n71RtfcltOtvZqIpX2lH1u4irR2mFo9JxDMB2d7Zm8CfBvt1.5PYXqjmpwD0v cINCq8jMJii5DPd_qxS6FLWRphrtIkXjRJQXLzbxcCxZ_lrCj.QJ0M6hvGbLVnuAk97nRAhu7LXw wA8G9pZxZKZsA0w68O28FNZu2XcnGBY9hRdWg.2cNdJq24ha_rZ.PSQEXYzTh27PCIA6QDDWXC4t z9F.PvaDRdMeNV2t5tAyEM2A9Fil02RucForUkD6We5or4jnUaJLOtnNfFqCbjpBC1FFJE.D49sb QXsV68L.j4JyXXAd7PIAIYd4NucOrAF0kB9VJMVHyx3pc5Ib4IX33IvvpKnh3vYXglL7oZ2VQK1Q ymplsDuzmleB5fCmCuOX_Wj8Gik5FPL4YvNXjyWCWoIrl0eD45piejfDBC.wnYddgv62v0WwwWuP tgORkGDryS0mBhO4bMmy5LFK9hb4U1b27tslkVD3ZSs14JyvrGW9UrVVQUIx1h1H0iA5VXDciHXL m5N8rAVLpH6ScJshFmG15MEklTkelG3E86KN9XSdBL0cVYjFjNcksA2S_y2bZ3w8mho09mM9KZtj pTv17rxUyRpoIeBxa3CaBFRM5NhEEwGEddB4o64P6KNuV8ahJzO.n8TnP3jbN3RZyk04H8TatrgZ jUJKNuAR7aP6Y7ZqpIg52Si414jOmmFFAJs1HLJjSvXV6aYH5XqSs7qmoPzOgNnVZTX2S2y_gZCz eR5.4mxXScfS7fJ9tKmnOH6W9Kl1gfPOXpd.jy85sVLLeJUw3vCMHebbkREm2b7SCfEuf7jwG0lT Ft8Jcu07KybAnBNAflP27qOnMMI0il2d2_bvt0xMwI9FQbKgpK8zFkFpIdRpsFOLOCcU6O5mP5pw PpotFjkOS4hRBgDCYKzEH5SPCsZFI5G84KdlEkZawXGo6bnNzW3UB1z7xiAsrBznBX218Ey1.n.o Fi4bVI_YeCfe4pxF0w5F_YtbnBsp4.p63B8oaPfc8CLZBXMkpZg6IAyEqUJpdXc49nrAuaNyfCgg YOx76jUO2MN8PBzfEAxZzbWqBm35T7T5NDGQv9bdmdW1TPNBQOo_DESdBWTK6ngdq2DsL2pzknaq i.kXwQl7yzPWLIl3wqXhXh8lWdv6NTklePc.iqTbCcCDerHL2e_U1e3wmlV2l62IeL_z24vW5jwb Xi44fiQnIk6CPWCoFWTeWfcMnk3Vu X-Sonic-MF: X-Sonic-ID: dae7a6d4-4d97-464d-95a1-e1bee6ed3a95 Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.ne1.yahoo.com with HTTP; Wed, 9 Apr 2025 02:23:59 +0000 Date: Wed, 9 Apr 2025 02:23:51 +0000 (UTC) From: Brent Wood Reply-To: Brent Wood To: amitabhkant@gmail.com, Achilleas Mantzios Cc: "pgsql-general@lists.postgresql.org" Message-ID: <1926549069.3386804.1744165431041@mail.yahoo.com> In-Reply-To: References: <31c8a0c0-ac43-4b11-a0fd-d038fcce3abe@cloud.gatewaynet.com> Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3386803_1262367883.1744165431039" X-Mailer: WebService/1.1.23590 YahooMailAndroidMobile Content-Length: 5416 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_3386803_1262367883.1744165431039 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I also use the free community edition on internal servers, but under Ubuntu= . No issues and very good performance. Brent Wood... Yahoo Mail: Search, organise, conquer=20 =20 On Wed, 9 Apr 2025 at 13:51, Amitabh Kant wrote: = On Tue, Apr 8, 2025 at 11:29=E2=80=AFPM Achilleas Mantzios wrote: =20 =20 On 8/4/25 20:37, Amitabh Kant wrote: =20 On Tue, Apr 8, 2025 at 9:40=E2=80=AFPM Achilleas Mantzios - cloud wrote: =20 Hi timescaledb seemed mature, but also exotic, allow me the term. No way to= =20 use native logical replication, shortage of options to run on premise or= =20 self hosted, which leaves us with those options : =20 =20 =20 =C2=A0 I cannot comment on the applicability of timescaledb in your contex= t, but running it on premise/self-hosted has posed no problems, at least on= Debian.=C2=A0=20 If I understood your query incorrectly, please ignore. =20 Thank you, I meant the paid/supported service not the community version. W= hich of the two do you use? =20 =20 I use the community version.=C2=A0=C2=A0 =20 ------=_Part_3386803_1262367883.1744165431039 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I also use the free community edition on internal servers, but under Ubuntu= . No issues and very good performance.

Brent Wood...
=

On Wed, 9 Apr 2025 at 13:51, Amitabh Kant
<amitabhkant@gmail.com> wrote:
On Tue, Apr 8, 2025= at 11:29=E2=80=AFPM Achilleas Mantzios <a.mantzio= s@cloud.gatewaynet.com> wrote:
=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:
H= i
<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?


I use the community version.&nb= sp; 
------=_Part_3386803_1262367883.1744165431039--