speed Archives

Tech Optimizer

June 19, 2026

Looking Ahead to Postgres 19

Postgres has introduced new functionalities, including UPDATE and DELETE FOR PORTION OF, enhancing temporal use cases. The expansion of RANDOM() temporal functions is attributed to Paul Ramsey and Greg Sabino Mullane. Version 19 includes performance improvements in the planner and executor components, with contributions from Tom Lane. Key enhancements include refinements in anti-joins and semi-joins, constant folding optimizations, incremental sorting with append paths, enhanced aggregate processing prior to joins, improved join selectivity computation, and more comprehensive function statistics. These changes allow Postgres to better understand query structures, reducing unnecessary processing. The visibility of memoization in EXPLAIN has improved, sort performance has benefited from radix sort, and foreign key constraint checks have become faster. The COPY FROM command can now utilize SIMD instructions. Postgres 19 offers a range of improvements for application developers, operators, performance enthusiasts, and those building on Postgres, including enhanced graph queries, refined SQL syntax, improved window functions, better upsert behavior, REPACK CONCURRENTLY, advancements in autovacuum, improved monitoring capabilities, and new hooks. The release is still in beta, providing an opportunity for testing applications, migration, extensions, execution plans, and maintenance workflows.

AppWizard

June 19, 2026

The new Epic Games Launcher might not suck so much thanks to ‘ground-up’ rebuild with 5–6.5x improved performance—still a long way to catch up with Steam

User sentiment towards the Epic Games Store is largely negative, with many gamers recognizing its shortcomings. A significant update is planned that includes a complete redesign of the launcher, promising a five times faster cold start time and a 6.5 times quicker restoration from the system tray. The update will also introduce new features such as personalized game recommendations, quick-access categories, tailored product detail pages, and patch notes on the storefront. Additional enhancements include community forums, player profiles, private messaging, voice chat, game-independent parties, cross-region game gifting, publisher-funded coupons, and a tool for assessing game compatibility.

AppWizard

June 19, 2026

Epic Games unveils Launcher V2 in re-attempt to topple Steam, says redesigned storefront is up to 6.5x faster — promises player profiles, user reviews, universal controller support, and much more

Epic Games is developing Epic Games Launcher V2, which will feature a complete internal overhaul to improve speed and expand its features. Key improvements include a complete reconstruction of the store, in-store Patch Notes, player reviews, a performance increase making the store 5 to 6.5 times faster, and universal controller support. The redesigned storefront will offer personalized game recommendations based on user preferences and will enhance game pages with more curated content. These updates will be released alongside updates to Fortnite.

Winsage

June 18, 2026

I discovered a dead‑simple way to remember Windows 11 shortcuts, and it changed how I use the OS

The Microsoft team behind PowerToys has released an updated Shortcut Guide in version 0.100 for Windows 11, which now appears as a context-sensitive flyout instead of a static reference page. This guide provides relevant keyboard shortcuts based on the application currently in use, improving user efficiency and learning. Users can access the Shortcut Guide by installing PowerToys and can customize its settings, including color theme and activation shortcut. The guide displays shortcuts for various applications and includes a list of Windows 11 and PowerToys shortcuts when no applications are focused. Developers can integrate their apps into the Shortcut Guide as well.

Winsage

June 18, 2026

Microsoft once used its own brand of ‘Lego’ to optimize Windows

Former Microsoft engineer Dave Plummer reflected on software performance challenges during the '90s, specifically the limitations of machines with 12 MB of RAM. He discussed the Basic Block Tool (BBT), which optimized software binaries by reorganizing their structures to enhance execution speed. A typical binary contained around 10 MB of code, but only about 300 KB was necessary for startup. If this essential code was scattered, it led to performance degradation due to excessive page access. BBT defragmented binaries, grouping related code to streamline access and improve user experience, particularly for large products like Windows and Office. Modern tools like BOLT and HP's Dynamo continue to optimize binary layouts and runtime code, but Plummer cautioned about the risks of manipulating binaries. He noted that while computational power has increased, modern software faces similar performance challenges, with larger binaries and complex dependency graphs. He emphasized the importance of locality in software design, advising to keep hot data and code together to enhance performance.

Tech Optimizer

June 18, 2026

I tested Norton’s Deepfake Protection — and it finally convinced me my next laptop needs an NPU

The landscape of online security has evolved significantly, with deepfake technology introducing new challenges. Users must be vigilant against both traditional malware and convincing fake images and videos. Antivirus software developers are enhancing their products by integrating cloud-based AI for better threat detection. For users with computers featuring neural processing units (NPUs), local solutions are available, such as Norton’s Deepfake Protection, which analyzes synthetic voices and images to flag potential threats. This feature operates in the background, providing peace of mind during online interactions. Norton 360 includes options for Deepfake Protection, Safe Web, and Safe SMS, but requires sufficient system resources to function effectively. Running this protection on older laptops may hinder performance, making NPUs a worthwhile investment for enhanced security against deepfakes and other online threats.

Tech Optimizer

June 18, 2026

Announcing Lakebase Search: agent-native retrieval built into Lakebase Postgres

Lakebase Search is a hybrid vector and full-text retrieval system integrated into Lakebase, now in beta on AWS and Azure. It utilizes two Postgres extensions: lakebase_vector and lakebase_text, allowing agents to operate on a single data backend. Agents manage four times more databases than human users and require real-time access to indexed data. The system features a tiered architecture that stores cold data in cost-effective object storage while keeping active data in local NVMe, significantly reducing costs. The lakebase_vector extension offers 32x compression for vectors, allowing a billion vectors to fit into under 10GB of RAM. The lakebase_text extension provides BM25 relevance ranking without high RAM usage. Benchmarking shows that Lakebase Search can efficiently handle large-scale workloads, achieving high recall and low latency with reduced resource requirements compared to traditional architectures. The system allows for continuous search experimentation and dedicated retrieval engines for each agent, enhancing operational efficiency and scalability.

Tech Optimizer

June 18, 2026

Companies turn to EnterpriseDB for AI data control

Organizations are increasingly adopting EnterpriseDB's EDB Postgres AI platform due to a rising demand for enhanced control over data in AI systems, particularly in sectors like banking, insurance, retail, and trading. Research from MIT Technology Review Insights indicates that prioritizing AI and data sovereignty significantly predicts success in AI initiatives, with such organizations achieving five times the return on investment. In South Korea, the Industrial Bank of Korea migrated 15 core systems to EDB Postgres AI, citing significant reductions in licensing costs compared to Oracle and improved scalability for future AI services. Shinhan EZ Insurance transitioned its core system to the public cloud using EDB, overcoming challenges related to legacy database licensing and emphasizing the importance of operational stability. Beyond finance, companies like MNTN, Euronext FX, and Kyobo Book Centre have adopted the platform to reduce vendor reliance, manage data workloads, and enhance compliance control. MNTN uses EDB for large-scale analytical processing, Euronext FX has implemented it across four data centers, and Kyobo Book Centre migrated from a costly data warehouse to the EDB solution. A common trend among these deployments is the use of a single Postgres-based platform for transactional processing, analytics, and AI tasks, reflecting an industry initiative to simplify operations and reduce costs. Hensley noted the critical convergence of AI systems with operational data, as AI agents operate against live data in high-volume workflows, highlighting the drawbacks of using separate platforms for transactions and analytics. EnterpriseDB has also received industry accolades for its data management and contributions to the open-source community, reinforcing its market position.

AppWizard

June 18, 2026

Stellaris’ Nomads expansion finally lets me live out my Battlestar Galactica fantasies, though its Wayline system could definitely use some work

Players in Stellaris experience an enchanting initial phase of exploration, discovering alien species, mega structures, and black holes. They must balance exploration with territory claiming, as resource management is crucial. Resources can be transported back to the Arkship or harvested directly from planets, though the latter incurs penalties. Nomadic players need to forge alliances and establish Wayline treaties to survive and thrive, while new resources like Operational Reserves add complexity. Upgrading the Arkship is rewarding, and the game features a vibrant post-Nomads era with new music and events enhancing gameplay.

AppWizard

June 17, 2026

I tried Bus Simulator 27 on PC, and it’s a super relaxing game… Until it just isn’t

Bus Simulator 27 is set to launch later this year, with a free demo available on Steam until June 22. The demo lacks support for DLSS or FSR, and during testing at 1440p on high settings with an RTX 5090, frame rates ranged from 70-80 FPS, with occasional drops. The AI traffic exhibits erratic behavior, often stopping abruptly and inconsistently adhering to speed limits, leading to penalties for the player in case of collisions. The voice acting can be distracting, interrupting the gameplay experience. The game is priced modestly, with additional content available for purchase, but there are concerns about optimization and AI dynamics that need addressing before the full release.