612 place 0
![[Translation] PostgreSQL 18: Part 1 or CommitFest 2024-07](https://times42.com/media/6/3/6/9539636_640x200.jpg "[Translation] PostgreSQL 18: Part 1 or CommitFest 2024-07")
This article is the first in the series about the upcoming PostgreSQL 18 release. Let us take a look at the features introduced in the July CommitFest.
Planner: Hash Right Semi Join support
Planner: materializing an internal row set for parallel nested loop join
Planner support functions for generate_series
EXPLAIN (analyze): statistics for Parallel Bitmap Heap Scan node workers
Functions min and max for composite types
Parameter names for regexp* functions
Debug mode in pgbench
pg_get_backend_memor
A newsletter a day!
You may get 10 most important news around midday in daily newsletter. Press the button and we will send you the most important news only, no spam attached.
LIKE us on Facebook so you won't miss the most important news of the day!
Habr
For over six decades, the “religious right” in America was boomer “Christian nationalism,” straight out of The Handmaid’s Tale. It was about “keeping God in the schools” and the National Prayer Breakfast. It was traditionalist, mindful of theology, and, well, theocratic, which is to say it wanted to take the standards of a religious tradition […] Read more ›
3,264 fresh
Apple today added the iPhone XS to the vintage products list on its website. Apple considers a device to be "vintage" once five years have passed since the company stopped distributing it for sale. Apple Stores and Apple Authorized Service Providers may still offer repairs for vintage devices, subject to parts availability. In two more years from now, the iPhone XS will be classified as fully obsolete, at which point... Read more ›
2,738 fresh
Air India, Qatar Airways, and Emirates have canceled or diverted flights. Iran, Israel, and Iraq closed their airspaces. Read more ›
2,539 fresh
Looking for NYT Strands answers and hints? Here's all you need to know to solve today's game, including the spangram. Read more ›
1,981 fresh
We’ll get this part out of the way very quickly. It has been for years now that other phone owners could natively control the brightness level of their phone’s flashlight feature. Meanwhile, Pixel owners are left to download 3rd-party apps to do the same thing, even though implementing this feature might’ve been a line of code … Continued Read the original post: Native Flashlight Controls on Pixel? Wild Android Fantasies... Read more ›
1,730 fresh
An anonymous reader quotes a report from The Register: US Navy Secretary John Phelan has told the Senate the service needs the right to repair its own gear, and will rethink how it writes contracts to keep control of intellectual property and ensure sailors can fix hardware, especially in a fight. Speaking to the Senate Armed Services Committee on Tuesday, Phelan cited the case of the USS Gerald R. Ford,... Read more ›
1,613 fresh
In macOS Tahoe, Apple introduces the concept of Themes, with new appearance settings that go beyond the traditional Light and Dark modes, allowing you to customize the look of your Mac desktop more than ever. Here's what's changed. In System Settings ➝ Appearance, there are still the standard Auto, Light, and Dark modes, but Apple has added several options that allow you to really mix things up and create your... Read more ›
1,430 fresh
Whether you’re a no-frills backpacker or a bag-checking fashionista, there’s a perfect packing cube out there for you. Read more ›
1,430 fresh
Alexandr Wang cofounded Scale AI. He's reportedly about to become a very expensive hire at Meta. Read more ›
1,406
These hard-working travel totes handle everything from a work trip to a weekend getaway. Read more ›
1,187 fresh
New research challenges previous theories suggesting the two young canines were domesticated dogs and reveals their surprising last meal. Read more ›
902 fresh
Google has completely revamped its Snapseed image editing app on iPhone and iPad. The change, spotted earlier by 9to5Google, is Snapseed’s first big update on iOS since adding dark mode in 2021. Snapseed was originally only available on iOS before Google acquired it in 2012 as part of a bid to compete with Instagram. Google […] Read more ›
853 fresh
On his personal blog, Eric Migicovsky, the creator of the original Pebble smartwatch, has shared some updates and important milestones about the smartwatches his new company plans to release this year. The Core 2 Duo smartwatch is “nearing mass production,” according to Migicovsky, and Core Devices is “on track to ship out all pre-orders in […] Read more ›
836 fresh
The ransomware group was also seen using open source tools in a bid to stay undetected. Read more ›
824 fresh
Late last month, approximately 1 billion news cycles ago, an obscure federal court made President Donald Trump very, very mad. The US Court of International Trade ruled unanimously on May 28 that the massive tariffs Trump imposed after taking office again are illegal. That ruling was suspended the next day by the US Court of […] Read more ›
790 fresh
If you installed iOS 26 Beta or iPadOS 26 Beta through Apple's Developer Program or Software Beta Program, you may decide you want to downgrade because of usability or stability issues. Keep reading to learn how it's done. Apple's beta versions of its major software updates can be notoriously buggy, especially the early releases. You may find apps not working properly, poor battery life, device crashes, and features that don't... Read more ›
788 fresh
Valve has quietly released a Steam Client Beta that runs natively on Apple Silicon, finally ending its reliance on the Rosetta 2 translation layer. The updated Steam client eliminates the performance overhead that plagued Mac gamers since Apple's transition to its own chips. Steam's Chromium-based interface, which could slow to a crawl on occasion, now runs directly on Apple Silicon rather than through Intel emulation. Early testers report dramatically faster... Read more ›
683 fresh
Since I became a mom, I've heard strangers everywhere say how fast kids grow up. At my last preschool drop off, I realized they'll never be little again. Read more ›
627 fresh
The 2026 budget request states that NSF will operate only one of the two LIGO sites, drastically reducing its cosmic listening ability. Read more ›
607 fresh
Habr
В настоящее время акселерометры встраивают куда только можно: в часы, автомобили, самокаты, LapTop-ы и прочее.В данном тексте изложена концепция распознавания аварии по данным с MEMS акселерометра. В этом тексте Вы узнаете зачем программисту микроконтроллеров надо знать дифференциальную геометрию. Read more Read more ›
0
Manual resource management in low level C-style C++ code might be annoying. It's not practical to create good enough RAII wrappers for every single C API you use, but approaches with goto cleanup or loads of nested if (success) hurt readability.A defer macro to the rescue! The deferred lambda will be executed on scope exit, no matter how it happens: you can return from any point, throw an exception (if... Read more ›
0
For years, we’ve studied Oracle to make PostgreSQL a more migration-friendly option. We introduced tools similar to SQL profile and SQL plan baseline as AQO and sr_plan extensions. In some cases, PostgreSQL even outperforms Oracle, especially in automatic re-optimization.Migrations from Oracle to PostgreSQL are usually smooth performance-wise, and we’ve even developed session variable extensions to make the transition easier. While many enterprise-only features exist, PostgreSQL often integrates popular sol Read more ›
0
We append the following metrics to the T-SQL procedure statements: execution count (x), CPU time in milliseconds (c), duration in microseconds (d), number of reads (r), number of writes (w), and @@rowcount value (n). You can display these as absolute values or percentages. Read more Read more ›
0
Всем привет! С вами Кирилл Филипенко, сисадмин из Selectel, и сегодня мы погрузимся в тему LLM-агентов. Сейчас об этих самых «агентах» кричат буквально из каждого утюга, поэтому пришло время наконец-то разобраться, что это такое, как они работают и с чем их, собственно, едят. Прыгайте под кат, будет интересно! Read more → Read more ›
0
Most popular sources
Business Insider
|
48% 17 |
Gizmodo
|
10% 4 |
Mashable
|
9% 6 |
Wired
|
6% 0 |
The Verge
|
5% 2 |
| View sources » | |
LIKE us on Facebook so you won't miss the most important news of the day!
13.06.2025 10:53
Last update: 10:46 EDT.
News rating updated: 17:42.
What is Times42?
Times42 brings you the most popular news from tech news portals in real-time chart.
Read about us in FAQ section.
popular
