Timescale Is Now TigerData
https://www.tigerdata.com/blog/timescale-becomes-tigerdata
#HackerNews #Timescale #TigerData #Database #Update #Technology #News
#Timescale
Mein AG sagt #Timescale kann mit #ADX nicht mithalten und es schon gar nicht ersetzen.
Wird also nichts mit der Unabhängigkeit von US Cloud.
Hat da jemand Einblick und vielleicht schon mal Projekte von ADX zu Timescale migriert?
Gerade auf der Arbeit die Datenbank durch Komprimierung um den Faktor 4 verkleinert und die Performance verbessert. Fühlt sich gut an.
Danke #Timescale #PostgresSQL
#Ukraine #TimeScale of #RuInvasion
"2014, russian invasion: timescale explained in one minute" [ ± 1min]
by StarskyUA
https://www.youtube.com/shorts/VLiNhhayz5o
Quote by SUA:
"2023, May 7
So, putin was courageously protecting people of Donbas who were being slaughtered by the Ukrainian revolutionaries? Explained in one minute."
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
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
I am pleased to have been able to improve the timescale documentation a little bit. That's the least I can do when using OpenSource software.
https://github.com/timescale/docs/pull/3401#issuecomment-2326503241
Are there any #PostgreSQL / #Timescale specialists here? I wonder if it is a bad idea to define very long running jobs. Here in particular it's about having a daily job that moves “old” hypertable chunks to another tablespace. Initially this takes a long time (several hours), later it should be faster, as there is not always something to do for all tables.
If we took the time dinosaurs have been extinct for and double it, it would still be less than the time they existed for.
📢 Stormatics and Timescale have joined forces to work closely and provide deep #PostgreSQL expertise for Stormatic’s customer product portfolio.
Read more about the announcement: https://bit.ly/46FWKPP
Shorts on Wheels Freitag und Radschnellwege Demo Samstag: da steht richtig was an!
Seid dabei!
#doodle, #Kalender, radfahren, #timetable, #Termine, #KIgeneriert, #Bild, #style, #Meetings, #Image, #Promt, Picsart, #Raddemonstration, #timescale,
http://warumichradfahre.blog/2023/11/05/du-willst-ein-date-du-kriegst-ein-date/
Termine Termine Termine
Seid dabei!
#doodle, #Kalender, radfahren, #timetable, #Termine, #KIgeneriert, #Bild, #style, #Meetings, #Image, #Promt, Picsart, #Raddemonstration, #timescale,
http://warumichradfahre.blog/2023/11/05/du-willst-ein-date-du-kriegst-ein-date/
Class:Chondrichthyes
Subclass:Elasmobranchii
Superorder:Selachimorpha
Order:Lamniformes
Family:Lamnidae
Genus:†Cosmopolitodus
Specie
†Cosmopolitodus hastalis Agassiz, 1843 (broad-toothed mako)
Lived from the Eocene epoch to the Pleistocene epoch
#Cosmopolitodus hastalis is an extinct specie of commonly known as broad-tooth #whitesharks. Fossils are found in the marine strata.
Photo found in facebook
Museo de Historia Naturalis, in Lima, Peru.
Now that Timescale compression works, we can see the massive drop in database size thanks to overnight jobs running on background workers
If you run a self-hosted instance of Timescale, be sure to monitor jobs:
- timescaledb_information.job* tables
- timescaledb.max_background_workers and max_worker_processes
- ensure background workers are started by running _timescaledb_internal.start_background_workers() (there's a typo in the doc #hacktoberfest 👀)
https://docs.timescale.com/self-hosted/latest/configuration/timescaledb-config/
https://docs.timescale.com/use-timescale/latest/user-defined-actions/troubleshooting/
The compression and retention jobs were not running on our instances, filling up disk 🚀
Goodness we love the #grafana pipeline.
You start off introducing it in a small project at work.
Next thing you know a colleague asks if you can help set it up for their item, then a few weeks later the Section Leader of your group asks if you can get it running for some of their systems.
As of now, we are having a trial run of monitoring all 1000+ Dipole Magnets of the #CERN #LHC, using #grafana, #timescale and some #Python running the #dataacquisition
#Observability for the win!
And after adding in the complete set of all #Cern #lhc Power Lead temperature sensors, the graph now looks far more stellar!
With 220 sensors providing data we are helping keep the accelerator's #superconductor magnets safely powered - and the data it generates looks absolutely fantastic as well
This graph here no longer shows a plot per individual sensor, but rather a heatmap of all sensors - beautifully visualising the operational heartbeat with #timescale and #grafana for plots <3
The heartbeat of a machine can be seen in many locations - in this case, in the monitoring of temperatures inside the #cern #lhc magnet power connectors using #grafana and #timescale
These connectors interface between the outside world and the cosmically cold cryogenics of the superconductor inside. If not monitored and heated, they can freeze and form ice and dew!
As the machine ramps power up and down, so do their temperatures, forming an imprint of the daily operations in the graphs.
Hackaday Prize 2023: Stretch Your Day With This 29-Hour Clock https://hackaday.com/2023/09/24/hackaday-prize-2023-stretch-your-day-with-this-29-hour-clock/ #multiple7-segmentdisplay #29-hourclock #clockhacks #timescale #clock #time
After two weeks of brainstorming, we have finally migrated:
- 7 #postgresql databases
- with #timescale hypertables
- used by #zabbix
- 1.8TiB
- 5 minutes of downtime
Some databases didn't have hypertables on the source but we needed them on destination.
The workload is now manageable for those databases 🎉
Don't forget to enable and configure Timescale from day 1 if you setup Zabbix running on PostgreSQL. That will be way easier than doing afterwards 👍🏻
https://www.zabbix.com/documentation/current/en/manual/appendix/install/timescaledb
Client Info
Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst