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 1u2qqf-006qgY-Ct for pgsql-general@arkaria.postgresql.org; Thu, 10 Apr 2025 12:17:37 +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 1u2qqd-00B3Ju-Om for pgsql-general@arkaria.postgresql.org; Thu, 10 Apr 2025 12:17:36 +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 1u2qqd-00B3Ji-Db for pgsql-general@lists.postgresql.org; Thu, 10 Apr 2025 12:17:35 +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 1u2qqb-004WHV-1i for pgsql-general@lists.postgresql.org; Thu, 10 Apr 2025 12:17:35 +0000 Content-Type: multipart/alternative; boundary="------------fLY7vpXQjqEnuTRsl0iaYBQJ" Message-ID: Date: Thu, 10 Apr 2025 15:17:27 +0300 MIME-Version: 1.0 Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm To: pcreso@yahoo.com Cc: "pgsql-general@lists.postgresql.org" References: <31c8a0c0-ac43-4b11-a0fd-d038fcce3abe@cloud.gatewaynet.com> <13b9a82e-6165-4237-a749-91a97c853595@cloud.gatewaynet.com> 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. --------------fLY7vpXQjqEnuTRsl0iaYBQJ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi 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)? On 10/4/25 08:25, Amitabh Kant wrote: > On Wed, Apr 9, 2025 at 11:50 AM Achilleas Mantzios - cloud > 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/separate 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. thanks --------------fLY7vpXQjqEnuTRsl0iaYBQJ Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

Hi 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)?

On 10/4/25 08:25, Amitabh Kant wrote:

On Wed, Apr 9, 2025 at 11:50 AM 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/separate 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.

thanks
--------------fLY7vpXQjqEnuTRsl0iaYBQJ--