Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-12 Thread Achilleas Mantzios
*From:* Achilleas Mantzios *Sent:* Friday, April 11, 2025 00:17 *To:* pcr...@yahoo.com *Cc:* pgsql-general@lists.postgresql.org *Subject:* Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Hi Brent how do you

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-12 Thread Brent Wood
, April 11, 2025 00:17 To: pcr...@yahoo.com Cc: pgsql-general@lists.postgresql.org Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm Hi Brent how do you plan to cope with future upgrades based on logical replication ? Do you run timescale on a dedicated/separate system

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-10 Thread Achilleas Mantzios
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:

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-09 Thread Amitabh Kant
On Wed, Apr 9, 2025 at 11:50 AM Achilleas Mantzios - cloud < a.mantz...@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

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-09 Thread Brent Wood
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 On Wed, 9 Apr 2025 at 13:51, Amitabh Kant wrote: On Tue, Apr 8, 2025 at 11:29 PM Achilleas Mantzios wrote: On 8/4/

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-08 Thread Achilleas Mantzios - cloud
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.

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-08 Thread Amitabh Kant
On Tue, Apr 8, 2025 at 11:29 PM Achilleas Mantzios < a.mantz...@cloud.gatewaynet.com> wrote: > > On 8/4/25 20:37, Amitabh Kant wrote: > > On Tue, Apr 8, 2025 at 9:40 PM Achilleas Mantzios - cloud < > a.mantz...@cloud.gatewaynet.com> wrote: > >> Hi >> >> timescaledb seemed mature, but also exotic,

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-08 Thread Achilleas Mantzios
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,

Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-08 Thread Amitabh Kant
On Tue, Apr 8, 2025 at 9:40 PM Achilleas Mantzios - cloud < a.mantz...@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 thos

timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm

2025-04-08 Thread Achilleas Mantzios - cloud
Hi in continuation of "Ideas about presenting data coming from sensors" https://www.postgresql.org/message-id/flat/8d2dd92a-da16-435b-a38e-fe72191fc9d1%40cloud.gatewaynet.com we got the system working in single tables fashion (3 kinds of them), since no timeseries solution seemed to fit 100% al