MIME-Version: 1.0
References: <b414b078-0e99-442b-b2ef-b7aad8819edc@cloud.gatewaynet.com>
 <CAPTAQB+cAaOE9MPWCErySRMqArG3ANAA4xmWb_GKUg_LKhpK3w@mail.gmail.com>
 <31c8a0c0-ac43-4b11-a0fd-d038fcce3abe@cloud.gatewaynet.com>
 <CAPTAQBL65BFbfTyiZQ7OZxryUXtgDteOwBoZjQhYNNtZpD6ysQ@mail.gmail.com> <13b9a82e-6165-4237-a749-91a97c853595@cloud.gatewaynet.com>
In-Reply-To: <13b9a82e-6165-4237-a749-91a97c853595@cloud.gatewaynet.com>
From: Amitabh Kant <amitabhkant@gmail.com>
Date: Thu, 10 Apr 2025 10:55:19 +0530
Message-ID: <CAPTAQBKzj7O_tjy+dAju1i6GMcxMV_kg+HBgY0DiE64ajYD6tQ@mail.gmail.com>
Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm
To: Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f4cde0063265d1cd"
Archived-At: <https://www.postgresql.org/message-id/CAPTAQBKzj7O_tjy%2BdAju1i6GMcxMV_kg%2BHBgY0DiE64ajYD6tQ%40mail.gmail.com>
Precedence: bulk

--000000000000f4cde0063265d1cd
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Apr 9, 2025 at 11:50=E2=80=AFAM Achilleas Mantzios - cloud <
a.mantzios@cloud.gatewaynet.com> wrote:

>
> On 4/9/25 04:50, Amitabh Kant wrote:
>
> Thank you, I meant the paid/supported service not the community version.
>> Which of the two do you use?
>>
>>
>> I use the community version.
>
>
> On 4/9/25 05:23, Brent Wood wrote:
>
> I also use the free community edition on internal servers, but under
> Ubuntu. No issues and very good performance.
>
> Brent Wood...
>
>
> Thanks Amitabh abd Brent, how do you plan to cope with future upgrades
> based on logical replication ? Do you run timescale on a dedicated/separa=
te
> system from the rest of your PostgreSQL cluster(s)?
>

I don't use the inbuilt logical replication. I depend upon pgBackRest for
my backups. My database is mainly time series data, and runs on the same
systems.

--000000000000f4cde0063265d1cd
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Apr 9, 2025 at 11:50=E2=80=AFAM A=
chilleas Mantzios - cloud &lt;<a href=3D"mailto:a.mantzios@cloud.gatewaynet=
.com">a.mantzios@cloud.gatewaynet.com</a>&gt; wrote:</div><div class=3D"gma=
il_quote gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><u></u>

 =20
   =20
 =20
  <div>
    <p><br>
    </p>
    <div>On 4/9/25 04:50, Amitabh Kant wrote:<br>
    </div>
    <blockquote type=3D"cite">
     =20
      <div dir=3D"ltr">
        <div class=3D"gmail_quote">
          <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8=
ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
            <div>Thank you, I meant the paid/supported service not the
              community version. Which of the two do you use?<br>
              <blockquote type=3D"cite">
                <div dir=3D"ltr">
                  <div class=3D"gmail_quote">
                    <div><br>
                    </div>
                  </div>
                </div>
              </blockquote>
            </div>
          </blockquote>
          <div>I use the community version.=C2=A0 <br>
          </div>
        </div>
      </div>
    </blockquote>
    <p><br>
    </p>
    <p>On 4/9/25 05:23, Brent Wood wrote:</p>
    <blockquote type=3D"cite">
      I also use the free community edition on internal servers, but
      under Ubuntu. No issues and very good performance.
      <div><br>
      </div>
      <div>Brent Wood...<br>
        <blockquote style=3D"margin:0px 0px 20px">
          <div style=3D"padding:10px 0px 0px 20px;margin:10px 0px 0px;borde=
r-left:1px solid rgb(109,0,246)">
            <div id=3D"m_6550531784230374866yiv2879466078">
              <div>
                <div id=3D"m_6550531784230374866yiv2879466078yqtfd71852">
                </div>
              </div>
            </div>
          </div>
        </blockquote>
      </div>
    </blockquote>
    <p></p>
    <p><br>
    </p>
    Thanks Amitabh abd Brent, how do you plan to cope with future
    upgrades based on logical replication ? Do you run timescale on a
    dedicated/separate system from the rest of your PostgreSQL
    cluster(s)?<br></div></blockquote><div><br></div><div>I don&#39;t use t=
he inbuilt logical replication. I depend upon pgBackRest for my backups. My=
 database is mainly time series data, and runs on the same systems.=C2=A0=
=C2=A0</div></div></div>

--000000000000f4cde0063265d1cd--