[sneak peak] Upcoming @TimescaleDB 2.19 release significantly improves write I/O spikes while refreshing its continuous aggregates (incremental materialized views).
Particularly useful whenever:
- Creating new caggs on top of historical raw data, or
- Supporting late-arriving data, which necessitates recomputing dependent aggregations (which Timescale handles seamlessly).
Notice the before (left) vs. after (right)? 🔥
New @CMUDB Course: Database Query Optimization!
A survey of how to build a SQL optimizer from scratch covering foundational and state-of-the-art implementations. All lectures available on Youtube: https://t.co/I8dMflK9dP
Thrilled to announce that @jana_puglierin and I are launching a pop-up podcast on the German election and its European & global dimensions:
SEARCHING FOR DEUTSCHLAND
will appear tomorrow, and weekly thereafter.
Subscribe via the links here: https://t.co/trXHJq46iB
New episode of the #TalkingPostgres podcast 🎙️
#PostgreSQL committer & major contributor Daniel Gustafsson surprised us all by joining the podcast to tell the story of how he got started as a developer & in Postgres 🐘
🎧 https://t.co/LWnGpl8XAo
📺 https://t.co/wZnHcoEerY
🇺🇦 „Bucha“ ist ein Spielfilm, der auf der wahren Geschichte von Konstantin Gudauskas basiert, einem Bürger Kasachstans, der im Frühjahr 2022 mehr als 200 Menschen aus Bucha und anderen besetzten Gebieten rettete. Es ist schwer, sich das anzusehen. Unten Trailer
@Gerashchenko_en
Hey Friends 👋 We've got an upcoming event that I'm very excited for! January 29 Postgres meetup event hosted by the wonderful people at AWS -- tell your friends 💫
https://t.co/o27Twdp1kG
Ausländisches Kapital unterstützt die Propaganda einer Partei, die in Deutschland die Demokratie zerstören will. Diese offene Form der Wahleinmischung ist ein Einschnitt.
Ще 189 наших вдома!
Військовослужбовці ЗСУ, НГУ, ДПСУ, ВМС та двоє цивільних зустрінуть Новий рік на рідній землі.
Відео: Координаційний штаб з питань поводження з військовополоненими
It will also be extremely important to analyze the strengths and limitations of the new system. Here are some examples of tasks that o3 couldn't solve on high-compute settings (even as it was generating millions of CoT search tokens and consuming thousands of dollars of compute in the process).
Interestingly this first task was the one we had in our university tour presentation to illustrate "it's easy for humans, hard for AI"
In da clurb, we all fam—especially in the PostgreSQL community! 😎🤟
That’s why we’ve extended the State of PostgreSQL Survey until October 31st! So whether you're a PostgreSQL pro or just vibing, we need your thoughts.
🧠 Don’t leave us hanging! Your insights help make PostgreSQL even more awesome— no cap. 🙅💥
Take the survey now: https://t.co/DqFoQEdkcF
#PostgreSQL #PostgresCommunity #OpenSource #TechInnovation #DatabaseDevelopment #Data #Databases #IOT #DataScience #Developers #Tech #FutureOfPostgres #TechCommunity #CommunitySurvey #DevCommunity #Postgres #AI
Happy #PostgreSQL 17 release day! Congrats to the whole development team and everyone helping PostgreSQL community to ship new releases! Looking forward to planner optimizations, vacuum speedup, better interoperability between logical and physical replication and many other improvements! What's you favorite new feature?
If you are in #Berlin, come to the #PostgreSQL meetup on October 9th to hear about new PostgreSQL 17 features and learn more about jsonb indexes.
https://t.co/BE38wFikfL
The 2024 State of PostgreSQL survey is open to everyone, and look at all our new community supporters!
Share your feedback, favorite extensions, community experiences, and more. 👇
https://t.co/yFBtSxLnAq
The survey is open until September 30 @ 11:59 p.m. PT ✨
If you want to support our organization @EuroResilience which works 24/7 for Ukraine and against Russian imperialism, you may donate here: https://t.co/z2pZRLleJP
Goodbye, Foreign Minister @DmytroKuleba. You were not the worst one, but as a Ukrainian living in 🇩🇪 for more than 11 years I won’t miss your populism and your disdain towards Ukrainians abroad.
Protecting the rights and interests of Ukrainian citizens abroad has always been and remains a priority for the MFA. At the same time, under the circumstances of Russia’s full-scale aggression, the main priority is to protect our Homeland from destruction.
How it looks like now: a man of conscription age went abroad, showed his state that he does not care about its survival, and then comes and wants to receive services from this state. It does not work this way. Our country is at war.
Besides, the obligation to update one's documents with the conscription centers existed even before the new law on mobilization was passed. If anyone believes that while someone is fighting far away at the frontline and risking his or her life for this state, someone else is staying abroad but receiving services from this state, then this is not how it works.
Staying abroad does not relieve a citizen of his or her duties to the Homeland. That is why yesterday I ordered measures to restore fair attitudes toward men of conscription age in Ukraine and abroad. This will be fair.
Soon, the Ministry of Foreign Affairs will provide further clarifications on the procedure for obtaining consular services within the legal framework for men of conscription age in foreign diplomatic missions as we approach the entry into force of the law "On Amendments to Certain Legislative Acts of Ukraine on Certain Issues of Military Service, Mobilization and Military Registration", as well as after it comes into force.
Russian missiles against our cities and people. The strike on Lviv killed 5 people, including a 14-year-old girl. My condolences go out to the families and loved ones of the victims. More than 30 people were injured. Ordinary residential buildings, schools, and medical facilities in the city were damaged.
In the Russian attack on Kryvyi Rih, 5 people were injured. Homes and civilian infrastructure were damaged. Our emergency services are on site, doing everything necessary to eliminate the aftermath of the attack. All the injured are receiving the required assistance.
Every one of our partners around the world who helps Ukraine with air defense is a true defender of life. Anyone who convinces partners to provide Ukraine with more long-range capabilities, enabling us to respond justly to terror, is working to prevent such Russian terrorist strikes on Ukrainian cities. Terror must be stopped.