#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."

#SlavaUkraini ! #HeroyamSláva!
#RussiaIsATerroristState

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

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.

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.

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!

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

A great article by the Timescale team on Performance Tuning and Optimizing Database Indexes in SQL: https://www.timescale.com/blog/postgresql-performance-tuning-part-iii-optimizing-postgresql-indexes/

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

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

Specious Timescales from Sedimentary Layers
Changing environments can dramatically change how quickly layers form in sedimentary rocks, leading to incorrect time estimates.
New research shows that environmental conditions can substantially affect how—and how fast—sediment accumulates, misleading scientists who are trying to estimate the lengths of time periods in Earth’s past.
https://eos.org/research-spotlights/specious-timescales-from-sedimentary-layers #sedimentary #layers #geohistory #timescale