#timescale — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #timescale, aggregated by home.social.
-
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
-
@alicefrieren Erm... Is it not clear that this is an actual photograph, and the technique used was a few million years of tectonic activity and erosion...? :)
The title refers to a passage from the Bible. I'm not religious, but it sometimes helps to take a "god's eye view" of things/landscapes to appreciate them more... Also see here for an old beautiful Persian legend with a similar context/insight (avid fans of Coldcut/Ninjatune might recognize the sample this was taken from):
"Now those people who fly have a different point of view of the world from the people who spend their whole life on the ground.
Don Blanding wrote a poem once when he was flying, and he called his poem "The God's Eye View", and he said it was so different from the view he always had on the ground, which he called "The Bug's Eye View".
Now I thought about that "Bug's Eye View" when I was over in Teheran in Persia. They told me an old Persian legend. It was about a bug who spent his entire life in the world's most beautifully designed Persian rug. All the bug ever saw in his lifetime was his problems. They stood up all around him. He couldn't see over the top of them, and he had to fight his way through these tufts of wool in the rug to find some crumbs somebody had spilled.
And the tragedy of the story of the bug in the rug was this:
He lived and he died in the world's most beautifully designed rug, but he never once knew that he spent his life in something which had a pattern.That's why I want you to get up in the air tonight, to see something the old bug couldn't see in the rug. Because even he, this bug, if he had once got above the rug so he could have seen all of it, he would have discovered something - that the very things he called his problems were a part of the pattern."
https://foxyde.com/wp-content/uploads/2013/07/bug_in_the_rug.pdf
-
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.
-
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/
-
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 - Modern life can be stressful. Many of us struggle to balance work, family, exercis... - 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 downtimeSome 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
-
We may once again be tasked with scraping/polling data off of a slow scientific "big data" database and into #Timescale for a smoother live plotting experience in #Grafana
You'd think CERN would use a dedicated time series store for monitoring data but no, its HDFS+Spark??
The kind of system that, when you ask people about, will say "Oh no I've managed to avoid worrying about it until now" and "It works if you're patient".
We'll give them a taste of sub-second query times~
-
Recently, we have discovered that some #zabbix databases running on #postgresql were maxing i/o capacity.
We have found out that the housekeeping job, responsible of removing old metrics, was responsible of thousand of DELETE queries. Enabling and configuring #timescale (via Zabbix config) drastically reduced the pressure.
How? By dropping chunks (partitions) instead of deleting rows one by one.
https://www.zabbix.com/documentation/current/en/manual/appendix/install/timescaledb
-
Slighlty disappointing to see #Influxdb 3's release saying it's "45x faster than Open Source" (referring to the Influx OSS version), and moving to a fully cloud-hosted system... And yet another rewrite, of course.
#timescale's TSL license feels more sensible, keeping the code open source and usable. We think they found a sustainable middle ground for their software, especially compared to what Influx just did.
-
Tag yourself I'm precambrian
-
"Implicit Transfer Operator Learning: Multiple Time-Resolution Surrogates for Molecular Dynamics"
https://arxiv.org/abs/2305.18046#MolecularDynamics #ComputationalModel #SurrogateModel #TimeScale #Simulation #DiffusionModel
-
It's intriguing that #PostgreSQL is both popular and underrated. Many people use it because it's for free, not knowing its superpowers.
I decided to explain why #PostgreSQL is so special, explaining the use case of Fleet Management and how it can help together with plugins like #Timescale and #PostGIS to build the real platform that detects the anomalies and pushes the notifications through #dotnet application to #React app!
https://event-driven.io/en/postgres_superpowers/
Feedback is more than welcome!
-
Let's rock, day two of @JavaLandConf just began with a welcome and the session of @noctarius2k about #postgresql and #timescale
-
@The_Colbobs
'#NuclearWaste is a resource that can be utilised' - Is this a JOKE?Nobody's utilising it. Nobody knows what to do with it. Everybody's trying to BURY it.
The human and environmental costs of a #NuclearAccident by faulty design/human error/act of God, are unacceptable. The #EconomicCost of building/removal is unacceptable. The #timescale of #degradation is unacceptable.
Building something that dangerous without knowing how to deal with the known effects is madness.
-
Im happy to be working with such amazingly talented people at #Timescale. We have been benchmarking Timescale Cloud vs RDS leading up to re:Invent 2022 and found some interesting things... 45% faster to ingest data, and up to 340x faster to query while using 95% less storage
-
Guess I will do a #fediverse #introduction just like everyone else. My name is Nick, I am currently working on Observability tooling at #timescale. I am into a lot of things mainly Linux, Kubernetes, Music (Jazz/Rock), Vinyl (mainly trying to find weird Japanese Jazz records), Tech and a lot more. I like I say I know a little about a lot of stuff. #mastodon feels new, but also old school at the same time. I hope to toot more here than I ever did on Twitter.
-
Timescale grabs $40M Series B as it goes all in on cloud version of time series database - Timescale, makers of the open source TimescaleDB time series database, announced a... - http://feedproxy.google.com/~r/Techcrunch/~3/8OG7d52tCBY/ #timeseriesdatabase #redpointventures #recentfunding #enterprise #opensource #timescale #startups #postgres #funding #cloud #saas #tc
