public inbox for [email protected]
help / color / mirror / Atom feedFrom: Achilleas Mantzios <[email protected]>
To: Brent Wood <[email protected]>
To: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: Amitabh Kant <[email protected]>
Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm
Date: Sun, 13 Apr 2025 08:13:41 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <SY7P300MB0761CA64924388B569EF4EA9A1B12@SY7P300MB0761.AUSP300.PROD.OUTLOOK.COM>
References: <[email protected]>
<CAPTAQB+cAaOE9MPWCErySRMqArG3ANAA4xmWb_GKUg_LKhpK3w@mail.gmail.com>
<[email protected]>
<CAPTAQBL65BFbfTyiZQ7OZxryUXtgDteOwBoZjQhYNNtZpD6ysQ@mail.gmail.com>
<[email protected]>
<CAPTAQBKzj7O_tjy+dAju1i6GMcxMV_kg+HBgY0DiE64ajYD6tQ@mail.gmail.com>
<[email protected]>
<SY7P300MB0761CA64924388B569EF4EA9A1B12@SY7P300MB0761.AUSP300.PROD.OUTLOOK.COM>
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 <[email protected]>
> *Sent:* Friday, April 11, 2025 00:17
> *To:* [email protected] <[email protected]>
> *Cc:* [email protected]
> <[email protected]>
> *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
>> <[email protected]
>> <mailto:[email protected]>> 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.
view thread (6+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: timescaledb vs NULL vs pg_timeseries vs partman + pgcron + pg_ivm
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox