#timescaledb — Public Fediverse posts

CVE Alert: CVE-2026-70634 - timescale - timescaledb - https://www.redpacketsecurity.com/cve-alert-cve-2026-70634-timescale-timescaledb/

#OSINT #ThreatIntel #CyberSecurity #cve-2026-70634 #timescale #timescaledb

CVE Alert: CVE-2026-70634 - timescale - timescaledb - https://www.redpacketsecurity.com/cve-alert-cve-2026-70634-timescale-timescaledb/

#OSINT #ThreatIntel #CyberSecurity #cve-2026-70634 #timescale #timescaledb

Automate data retention in TimescaleDB: the add_drop_chunks_policy function schedules background jobs to drop entire chunks older than 90 days from your hypertable. This metadata operation removes underlying PostgreSQL table partitions efficiently.

#timescaledb #retention #ValtersIT

https://www.valtersit.com/vault/data-retention-policy-with-drop-chunks-7afa3c/

Разговариваем с датчиками на человеческом: как связать MQTT, TimescaleDB и LLM через Model Context Protocol (MCP)

А что, если не писать сложные SQL-запросы, не выгружать логи в CSV и не строить графики в Python? Просто спрашиваете у AI-агента: «Покажи максимальную температуру на объекте за выходные и нарисуй гистограмму». Ответ готов за секунды. В статье расскажем, как объединить «мозги» языковых моделей с настоящими промышленными данными. Развернём стек: MQTT (Mosquitto), Telegraf, TimescaleDB на Ubuntu, а потом напишем собственный MCP-сервер на Go. Так ваша LLM сможет безопасно и быстро анализировать телеметрию с датчиков, общаясь на простом языке. Минимум воды, максимум готового кода, Docker-конфигов и примеров из практики.

https://habr.com/ru/articles/1052000/

#mcp #mqtt #промышленная_автоматизация #умный_дом #ai_agent #ai #opencode #timescaledb #telegraf

📰 Oh, look! A 12-minute read on how #TimescaleDB compresses data, because obviously, everyone has time to delve into the wonders of #Hypercore and Columnar Storage. 🤔 But hey, if watching paint dry isn't your style, imagine the thrill of squeezing data "up to 98" – whatever that means! 🙄
https://roszigit.com/en/blog/timescaledb-compression-hypercore #DataCompression #ColumnarStorage #TechTrends #HackerNews #ngated

📰 Oh, look! A 12-minute read on how #TimescaleDB compresses data, because obviously, everyone has time to delve into the wonders of #Hypercore and Columnar Storage. 🤔 But hey, if watching paint dry isn't your style, imagine the thrill of squeezing data "up to 98" – whatever that means! 🙄
https://roszigit.com/en/blog/timescaledb-compression-hypercore #DataCompression #ColumnarStorage #TechTrends #HackerNews #ngated

How TimescaleDB compresses time-series data

https://roszigit.com/en/blog/timescaledb-compression-hypercore

#HackerNews #TimescaleDB #time-series #data #compression #dataengineering #database #performance

How TimescaleDB compresses time-series data

https://roszigit.com/en/blog/timescaledb-compression-hypercore

#HackerNews #TimescaleDB #time-series #data #compression #dataengineering #database #performance

Писал мониторинг на Go «за выходные» — застрял на месяцы. Вот на чём

В этой статье я расскажу, на какие подводные камни я споткнулся при разработке своего пет‑проекта — мониторинга сайтов на Golang, аналог UptimeRobot. Начнем издалека... Я хотел разработать пет‑проект, но не банальный todolist, а что‑то свежее, интересное в плане архитектуры и реализации. Шерстя по просторам интернета, я наткнулся на UptimeRobot — сервис для мониторинга сайтов. Азарт и любопытство взяли верх и я начал продумывать, как буду разрабатывать «свой» UptimeRobot. Думал — делов на пару недель от силы. Ведь принцип прост: дергать URL по таймеру и проверять код ответа и всё. Но на практике все оказалось намного сложнее, чем я изначально представлял...

https://habr.com/ru/articles/1046696/

#мониторинг #мониторинг_сайта #go #golang #uptime #горутины #ssrf #DNS_rebinding #timescaledb #postgresql

We shrank our TimescaleDB chunks from 30 days to 7

https://tech.wmg.com/why-we-shrank-our-timescaledb-chunks-from-30-days-to-7-07cab8afefc5

#HackerNews #TimescaleDB #database #optimization #dataengineering #chunking #performance

We shrank our TimescaleDB chunks from 30 days to 7

https://tech.wmg.com/why-we-shrank-our-timescaledb-chunks-from-30-days-to-7-07cab8afefc5

#HackerNews #TimescaleDB #database #optimization #dataengineering #chunking #performance

I like #TimescaleDB for storing time-based data...

...until I have to find a row by the given ID, which is 90% of the time.

In other words, I use TimescaleDB 10% of the time, and with that usecase, I literally don't use it at all because it adds another shit to worry about.

Once it works for both use cases, I'll may take a look on that.

#Programming #Coding #Code #SQL #Database #Databases #DB #RDBMS #PostgreSQL #PGSQL #OpenSource #FreeOpenSource #OSS #FOSS

I like #TimescaleDB for storing time-based data...

...until I have to find a row by the given ID, which is 90% of the time.

In other words, I use TimescaleDB 10% of the time, and with that usecase, I literally don't use it at all because it adds another shit to worry about.

Once it works for both use cases, I'll may take a look on that.

#Programming #Coding #Code #SQL #Database #Databases #DB #RDBMS #PostgreSQL #PGSQL #OpenSource #FreeOpenSource #OSS #FOSS

Как я выбирал стек для SaaS-мониторинга сайтов

Как в одиночку собрать полноценный сервис мониторинга с проверками из 10 точек мира, алертами в Telegram/Slack и собственным агентом? Делюсь личным опытом выбора стека: почему FastAPI выиграл у Django, как TimescaleDB справляется с миллионами строк логов и зачем писать агент на Go, если основной код на Python. Только практика, архитектурные решения и честный расчет стоимости инфраструктуры в €11/мес. Изучить стек

https://habr.com/ru/articles/1021000/

#FastAPI #Vuejs #TimescaleDB #SaaS #мониторинг_сайтов #Celery #Go #архитектура #стартап #разработка

#timescaledb extension for #postgres compressed a 170GB database (10^9 rows of IoT observations) into 32GB. Nice!

#timescaledb extension for #postgres compressed a 170GB database (10^9 rows of IoT observations) into 32GB. Nice!

Explore TimescaleDB for IoT!

Michal Bartak shows how to collect & visualize data using continuous aggregates, compression, and retention strategies. Learn how dataset types impact Grafana dashboards and maintain your time-series data efficiently.

#PostgreSQL #TimescaleDB #IoT #P2D2

Explore TimescaleDB for IoT!

Michal Bartak shows how to collect & visualize data using continuous aggregates, compression, and retention strategies. Learn how dataset types impact Grafana dashboards and maintain your time-series data efficiently.

#PostgreSQL #TimescaleDB #IoT #P2D2

[Перевод] Реализация TimescaleDB в Zabbix: преимущества, ключевые таблицы и установка

Всем привет! Мы делаем проекты по Zabbix, накопили большую экспертизу и решили сделать переводы нескольких статей, которые нам показались интересными и полезными. Наверняка, будут полезны и вам. Также своим опытом делимся в телеграм-канале zabbix_ru , где вы можете найти полезные материалы и записи наших вебинаров, опубликованных на нашем ютуб-канале (прим. переводчика). Ниже ссылки на предыдущие статьи из цикла. Миграция с MySQL на PostgreSQL SELinux: интеграция с Zabbix и другими инструментами Защита от ложных срабатываний триггеров в Zabbix с использованием функций min/max/avg Zabbix – автоматизация управления пользователями (JIT) Zabbix — это надежное решение с открытым исходным кодом для мониторинга ИТ-инфраструктуры, позволяющее отслеживать и анализировать производительность сети, серверов, приложений и других компонентов. По мере роста объема данных эффективное управление временными рядами становится ключевым фактором. Поэтому, начиная с версии 5.0, Zabbix начал поддерживать TimescaleDB — расширение PostgreSQL, оптимизированное для временных рядов. В этой статье рассматриваются преимущества использования TimescaleDB в Zabbix, ключевые таблицы и процесс установки. Подробности под катом.

https://habr.com/ru/articles/970702/

#zabbix #timescaledb #gals_software #postgresql

We have PostgreSQL 14 on Debian 11 with TimescaleDB 2.16.1.
We want PostgreSQL 18 on Debian 13 with TimescaleDB 2.23.1.

But the support of TimescaleDB on PostgreSQL 14 ends at version 2.19.3.

On Debian 13 and PostgreSQL 18, the minimum version of TimescaleDB available is 2.23.0.

We have to upgrade with an intermediary step:

1. Upgrade TimescaleDB to 2.19.3 in-place
2. Upgrade to PostgreSQL 17 on Debian 12 (with TimescaleDB 2.19.3)
3. Upgrade TimescaleDB to 2.23.1
4. Upgrade to PostgreSQL 18 on Debian 13 (with TimescaleDB 2.23.1).

Add a multi-terabytes of data making dump/restore impossible.

At least the extension is available on Debian 13 which is not the case of age and Citus.

This is nice to have a 5 years support on PostgreSQL but beware if you use extensions. The time window could be less than that, complicating the upgrade process.

#postgresql #timescaledb #age #citus #upgrade #debian

We have PostgreSQL 14 on Debian 11 with TimescaleDB 2.16.1.
We want PostgreSQL 18 on Debian 13 with TimescaleDB 2.23.1.

But the support of TimescaleDB on PostgreSQL 14 ends at version 2.19.3.

On Debian 13 and PostgreSQL 18, the minimum version of TimescaleDB available is 2.23.0.

We have to upgrade with an intermediary step:

1. Upgrade TimescaleDB to 2.19.3 in-place
2. Upgrade to PostgreSQL 17 on Debian 12 (with TimescaleDB 2.19.3)
3. Upgrade TimescaleDB to 2.23.1
4. Upgrade to PostgreSQL 18 on Debian 13 (with TimescaleDB 2.23.1).

Add a multi-terabytes of data making dump/restore impossible.

At least the extension is available on Debian 13 which is not the case of age and Citus.

This is nice to have a 5 years support on PostgreSQL but beware if you use extensions. The time window could be less than that, complicating the upgrade process.

#postgresql #timescaledb #age #citus #upgrade #debian

Почему простой парсер не всегда решает задачу: мой опыт интеграции спортивных API

В рамках собственной системы спортивной аналитики я хотел получить real-time доступ к данным о движении коэффициентов — в частности, с платформы pickingodds.com. У сервиса интересная фича — визуализация графика изменения линии по каждому событию. Это потенциально полезный источник вторичных сигналов (например, для обнаружения аномалий, связанных с резкой коррекцией маркет-мейкеров). Изначальный план был прост: интегрироваться по REST API, выкачивать данные раз в несколько минут, писать в TSDB, использовать далее для анализа и фичей в ML-пайплайнах. На практике же всё быстро ушло в зону нетривиальной оптимизации.

https://habr.com/ru/articles/930360/

#pickingodds #коэффициенты_ставок #асинхронный_парсинг #rate_limiting #aiohttp #Redis #Kafka #TimescaleDB #LightGBM #ML_фильтрация_событий

#QuestDB 9.0.0 has been released (#SQL / #TimeSeriesDBMS / #InfluxDB / #eXtremeDB / #MongoDB / #TimescaleDB / #DBMS / #RDBMS / #Database / #DB) https://questdb.io/

#QuestDB 9.0.0 has been released (#SQL / #TimeSeriesDBMS / #InfluxDB / #eXtremeDB / #MongoDB / #TimescaleDB / #DBMS / #RDBMS / #Database / #DB) https://questdb.io/

When dealing with #logs, forget about #ELK prefer TGV or MTV 😎

https://github.com/MTES-MCT/qualicharge-logs

#timescaledb #vector #metabase #grafana

When dealing with #logs, forget about #ELK prefer TGV or MTV 😎

https://github.com/MTES-MCT/qualicharge-logs

#timescaledb #vector #metabase #grafana

How difficult can be creating an hypertable in TimescaleDB?

It seems that pretty much of a fucking lot.

#PostgreSQL #TimescaleDB #Hypertable #Hypertables #SQL #RDBMS #RelationalDatabase #Database #Databases #Programming #SoftwareDevelopment #DatabaseDevelopment

How difficult can be creating an hypertable in TimescaleDB?

It seems that pretty much of a fucking lot.

#PostgreSQL #TimescaleDB #Hypertable #Hypertables #SQL #RDBMS #RelationalDatabase #Database #Databases #Programming #SoftwareDevelopment #DatabaseDevelopment

Lyon: PostgreSQL, TimescaleDB, Kubernetes et ..., Le mardi 22 avril 2025 de 19h00 à 22h00. https://www.agendadulibre.org/events/32367 #postgresql #timescaledb #kubernetes #postgresqlLyonUserGroup #soirée

Lyon: PostgreSQL, TimescaleDB, Kubernetes et ..., Le mardi 22 avril 2025 de 19h00 à 22h00. https://www.agendadulibre.org/events/32367 #postgresql #timescaledb #kubernetes #postgresqlLyonUserGroup #soirée

TIL: you cannot simply dump and restore a PostgreSQL database with the TimescaleDB extension, you have to tell the extension you are dumping the database, then dump/restore and finally tell the extension you have finished the dump. You also have to make sure both clusters have the same TimescaleDB version available.

https://docs.timescale.com/self-hosted/latest/migration/entire-database/

#postgresql #timescaledb

TIL: you cannot simply dump and restore a PostgreSQL database with the TimescaleDB extension, you have to tell the extension you are dumping the database, then dump/restore and finally tell the extension you have finished the dump. You also have to make sure both clusters have the same TimescaleDB version available.

https://docs.timescale.com/self-hosted/latest/migration/entire-database/

#postgresql #timescaledb

@ron vielleicht schaust du dir mal #influxdb an. Da kannst du pro bucket definieren wie lange die Daten aufbewahrt werden. Spielt auch gut mit #grafana für Visualisierungen zusammen.

Wir benutzen aber #timescaledb, damit können wir z.b. für Verbräuche, also laufende Zähler, erreichen, das 14 Tage minütliche Werte, danach nur noch 15 min aggregierte Werte und nach einem halben Jahr 1h Werte gespeichert werden. So kann man immer noch Vergleiche mit dem letzten Jahr anstellen.

No Time for Caution: Getting Started with #TimescaleDB #postgresql https://brojonat.com/posts/timescale-db-getting-started/

No Time for Caution: Getting Started with #TimescaleDB #postgresql https://brojonat.com/posts/timescale-db-getting-started/

A #TimescaleDB #analytics trick #postgresql https://kmoppel.github.io/2024-08-19-a-timescaledb-analytics-trick/

A #TimescaleDB #analytics trick #postgresql https://kmoppel.github.io/2024-08-19-a-timescaledb-analytics-trick/

cloudnative-pg was such a great overall experience so far, every time i'd run into something the answer ends up to be

> oh, the have actually thought about it already and their solution is much better than what i came up with

like look at this timescale setup, it's so clean and neat and ready to go literally in 5 minutes. I had more hustle setting it up on my laptop as a standalone deployment

https://github.com/clevyr/docker-cloudnativepg-timescale

#postgresql #timescaledb #homelab

The disk space alert has been raised again on a PostgreSQL cluster with Zabbix databases using TimescaleDB.

After some investigation, the HouseKeeper wasn't doing its retention job. Data from 1 year ago was still present where we should only keep 15 days!

The issue is now fixed. It's always a pleasure to see such disk space vanish in the void.

#postgresql #zabbix #timescaledb

The disk space alert has been raised again on a PostgreSQL cluster with Zabbix databases using TimescaleDB.

After some investigation, the HouseKeeper wasn't doing its retention job. Data from 1 year ago was still present where we should only keep 15 days!

The issue is now fixed. It's always a pleasure to see such disk space vanish in the void.

#postgresql #zabbix #timescaledb

🚀 #TimescaleDB enhances #Postgres for time-series data and real-time #analytics:

• 📊 Hyperstore: Hybrid storage approach for efficient data handling
• 🏎️ Chunk-skipping: 7x faster queries, 87% less storage
• 🔄 Compressed tuple filtering: 500x faster updates and deletes
• 📈 Index scans: 360x faster upserts for high-cardinality datasets
• 💾 Tiered storage optimizations: 400x faster queries on data in #S3

#DatabaseOptimization #PerformanceBoost #DataManagement #DevOps #database

Key improvements:
- Intelligent data partitioning and querying
- Efficient compression and decompression techniques
- Optimized index usage for upserts
- Enhanced tiered storage architecture

https://www.timescale.com/blog/making-postgres-faster/amp/

🚀 #TimescaleDB enhances #Postgres for time-series data and real-time #analytics:

• 📊 Hyperstore: Hybrid storage approach for efficient data handling
• 🏎️ Chunk-skipping: 7x faster queries, 87% less storage
• 🔄 Compressed tuple filtering: 500x faster updates and deletes
• 📈 Index scans: 360x faster upserts for high-cardinality datasets
• 💾 Tiered storage optimizations: 400x faster queries on data in #S3

#DatabaseOptimization #PerformanceBoost #DataManagement #DevOps #database

Key improvements:
- Intelligent data partitioning and querying
- Efficient compression and decompression techniques
- Optimized index usage for upserts
- Enhanced tiered storage architecture

https://www.timescale.com/blog/making-postgres-faster/amp/

Watching a presentation by @[email protected] about #timescaledb in #postgres for Postgres Usergroup Belgium

Meetup announcement 📢

Next week, on Friday 6 at 17:30 CEST, I will talk about time series management at work using TimescaleDB at the PgBE PostgreSQL Users Group Belgium :postgres_logo: 🐯 🇧🇪

This is an online event so feel free to join!

https://www.meetup.com/postgresbe/events/303135515/

Thanks @tchorix for the invitation 🙏

#meetup #postgresql #timescaledb

We love open source 💛

This is why we have opened our Nagios Plugins 🚀

https://github.com/ovh/ovh-nagios-plugins

For now, we have probes to check TimescaleDB and MongoDB.

Soon, we should have one for MySQL including support for Group Replication and Cluster Sets.

And many more in the future 🤞🏻

#nagios #timescaledb #mongodb #mysql #foss

”#Postgres is for everything”

https://se-radio.net/2024/07/se-radio-623-mike-freedman-on-timescaledb/

#TimeScaleDB

All benchmarks are liars.

Also, here’s a set of db benchmarks from #clickhouse:

https://benchmark.clickhouse.com/

Various DBs including:
- #mysql
- #postgres
- #sqlite
- #timescaledb
- #alloydb
- #mariadb

New release of #TimescaleDB yesterday (2.16.0). Notified by GitHub e-mail on release. Already running on our infrastructure 😎

Wanted to switch from InfluxDB to TimescaleDB (because Influx kinda sucks) and was annoyed that I had to create all the tables by hand.

So I wrote a (kinda hacky) MQTT to TimescaleDB gateway where mqtt->table+field mapping is defined by code, and tables, fields and indices are created and extended automatically.

https://github.com/patagonaa/mqtt-timescaledb-gateway

#InfluxDB #InfluxQL #TimescaleDB #PostgreSQL #MQTT #NodeJS

Side-things to do in my backlog:
- Open Nagios NRPE check for #MongoDB
- Open Nagios NRPE check for #TimescaleDB
- Deploy Event-Driven #Ansible
- Test database schema migrations on a #ZFS clone before prod

My next talks, if accepted, will define the priorities🤞🏻

But before, I will enjoy family time with 2 weeks off between Netherlands, Belgium and France 😎

#QuestDB 8.0.1 has been released (#SQL / #TimeSeriesDBMS / #InfluxDB / #eXtremeDB / #MongoDB / #TimescaleDB / #DBMS / #RDBMS / #Database / #DB) https://questdb.io/

When I worked on clevabit (my own startup) we ran our database in #Kubernetes (obviously #Postgresql with #TimescaleDB 😍).

Using persistent volumes sounds easy, but there are considerations you should be aware of. This is my personal set, what am I missing? 🫣🤯

https://www.simplyblock.io/post/kubernetes-persistent-volumes-how-to-best-practices

via @simplyblock

Ganz nebenbei: Ziemlich beeindruckend, dass #TimescaleDB hier auf meinem Resterampen-Server in weniger als 8 Sekunden ~4,4 Millionen Datensätze aggregiert.