Feedback-ID: i76984098:Fastmail
Message-ID: <fb8407de-41dd-412c-aa79-ef10e7276517@aklaver.com>
Date: Wed, 26 Feb 2025 08:29:21 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Ideas about presenting data coming from sensors
To: Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>,
 pgsql-general@lists.postgresql.org
References: <8d2dd92a-da16-435b-a38e-fe72191fc9d1@cloud.gatewaynet.com>
 <ea77fa23-6361-42f0-a511-8e0997dada26@aklaver.com>
 <d8892101-4cab-4f42-8c8b-9a84cb8ff767@cloud.gatewaynet.com>
 <f80fdc40-3179-4686-b8bf-4f45bb930b4d@gelassene-pferde.biz>
 <CAF3N6oR+8VvfrDEfp-VMD2FmTkPc4mLdqRixBgARCyuqjQHqpw@mail.gmail.com>
 <44a0b638-58f6-4a81-aadc-88aac3e2a842@cloud.gatewaynet.com>
 <a6d496e4-7f44-4bd9-86d9-d109df62a128@cloud.gatewaynet.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <a6d496e4-7f44-4bd9-86d9-d109df62a128@cloud.gatewaynet.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/fb8407de-41dd-412c-aa79-ef10e7276517%40aklaver.com>
Precedence: bulk

On 2/26/25 01:27, Achilleas Mantzios - cloud wrote:
> Hi Again
> 
> Up to this day we have set the data acquisition system running for just 
> one ship and writing the code to display the data. For less than 20 days 
> we have 6M rows.
> 
> I gave a shot to timescale, installed locally as an extension, it seems 
> much prettier than having to do all the partition mgmt by hand or other 
> tools. However this seems more than a complete engine with its own 
> workers, so this seems like something new and big which seems to me like 
> something to commit to for a long time, something to invest, on top of 
> the already 25+ commitment we have with PostgreSQL itself.
> 
> So this is serious decision, so ppl please share your stories with 
> timescale .
> 

I don't use timescale, so this will not be about specifics. It seems to 
me you are well on the way to answering your own question with the 
choices you presented:

a) '... it seems much prettier than having to do all the partition mgmt 
by hand or other tools.'

b) 'However this seems more than a complete engine with its own
workers, ...'

Either you do the work to build your own solution or you leverage off 
other folks work. The final answer to that comes down to what fits your 
situation. Which solution is easier to implement with the resources you 
have available. Either one is going to end up being a long term commitment.


-- 
Adrian Klaver
adrian.klaver@aklaver.com