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

Thank you Brent and Amitabh

On 13/4/25 00:21, Brent Wood wrote:
> 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
> ------------------------------------------------------------------------
> *From:* Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>
> *Sent:* Friday, April 11, 2025 00:17
> *To:* pcreso(at)yahoo(dot)com <pcreso(at)yahoo(dot)com>
> *Cc:* pgsql-general(at)lists(dot)postgresql(dot)org
> <pgsql-general(at)lists(dot)postgresql(dot)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:
>> On Wed, Apr 9, 2025 at 11:50 AM Achilleas Mantzios - cloud
>> <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com
>> <mailto:a(dot)mantzios(at)cloud(dot)gatewaynet(dot)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
> <https://www.niwa.co.nz> Brent Wood
> Principal Technician - GIS and Spatial Data Management
> Programme Leader - Environmental Information Delivery
> +64-4-386-0529
>
> National Institute of Water & Atmospheric Research Ltd (NIWA)
> 301 Evans Bay Parade Hataitai Wellington New Zealand
> *Connect with NIWA:* niwa.co.nz <https://www.niwa.co.nz> Facebook
> <https://www.facebook.com/nzniwa> LinkedIn
> <https://www.linkedin.com/company/niwa> Twitter
> <https://twitter.com/niwa_nz> Instagram
> <https://www.instagram.com/niwa_science> YouTube
> <https://www.youtube.com/channel/UCJ-j3MLMg1H59Ak2UaNLL3A>
>
> To ensure compliance with legal requirements and to maintain cyber
> security standards, NIWA's IT systems are subject to ongoing
> monitoring, activity logging and auditing. This monitoring and
> auditing service may be provided by third parties. Such third parties
> can access information transmitted to, processed by and stored on
> NIWA's IT 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.