Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm
От | Brent Wood |
---|---|
Тема | Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm |
Дата | |
Msg-id | SY7P300MB0761CA64924388B569EF4EA9A1B12@SY7P300MB0761.AUSP300.PROD.OUTLOOK.COM обсуждение исходный текст |
Ответ на | Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm (Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>) |
Ответы |
Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm
|
Список | pgsql-general |
Our Timescale dbs are on individual hosts, separate from our main Postgres servers.
So standalone systems to be upgraded individually as required.
Brent Wood
Principal Technician, Fisheries
NIWA
DDI: +64 (4) 3860529
Principal Technician, Fisheries
NIWA
DDI: +64 (4) 3860529
From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
Sent: Friday, April 11, 2025 00:17
To: pcreso@yahoo.com <pcreso@yahoo.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm
Sent: Friday, April 11, 2025 00:17
To: pcreso@yahoo.com <pcreso@yahoo.com>
Cc: pgsql-general@lists.postgresql.org <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 from the rest of your PostgreSQL cluster(s)?
On 10/4/25 08:25, Amitabh Kant wrote:
thanksOn 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.
![]() |
Note: This email is intended solely for the use of the addressee and may contain information that is confidential or subject to legal professional privilege. If you receive this email in error please immediately notify the sender and delete the email.
В списке pgsql-general по дате отправления: