#geocom2025 Jean Pommier de pi-Geosolutions détaille le travail en cours sur le nouveau module #Analytics de #geOrchestra financé par @geo2france et son workflow basé sur #timescaleDB et #Superset

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

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

#timescaledb #vector #metabase #grafana

최근 Django에서 선언적 테이블 파티셔닝 사용해본 케이스 공유

https://hackers.pub/@thiefbird/2025/%EC%B5%9C%EA%B7%BC-django%EC%97%90%EC%84%9C-%EC%84%A0%EC%96%B8%EC%A0%81-%ED%85%8C%EC%9D%B4%EB%B8%94-%ED%8C%8C%ED%8B%B0%EC%85%94%EB%8B%9D-%EC%82%AC%EC%9A%A9%ED%95%B4%EB%B3%B8-%EC%BC%80%EC%9D%B4%EC%8A%A4-%EA%B3%B5%EC%9C%A0

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

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/

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

Brand new #OpenSource tool for #PostgreSQL - pgai Vectorizer - just launched today from #TimescaleDB! Manage #embeddings with just one #SQL command to keep embeddings in sync with your data in a far easier fashion.

Learn more on the #GitHub repository here: https://github.com/timescale/pgai/blob/main/docs/vectorizer.md

#postgres #timescale #pgai #pgvector #vector #ai #llama

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/

Next up to watch on the livestream at @pgdaylowlands is @jriou - he's presenting about "Efficient Time Series Management with #TimescaleDB at @mipsytipsy

https://www.youtube.com/live/ZPR7u44YJKI

Happening now!

Subscribe to @pgdaylowlands to watch the recording to be posted later on 🐘

#timeseries #opensource #foss #database #datamanagement #databaseadministration #dba #sql #rdbms

Are you listening? Jérémie Grauer is speaking at @pgdaylowlands about "#Postgres nightmare stories" - listen in on the livestream: https://www.youtube.com/live/ZPR7u44YJKI

Next up: "Efficient Time Series Management with #TimescaleDB at @OVHcloud with @jriou

#datamanagement #sql #postgresql #dba #databaseadministration #database #learnsql #techwebinar #learntech #tech #opensource #foss #timeseries #timescale

Watching a presentation by @jriou@hachyderm.io 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