NewApp Digest
search bot

execution

PostgreSQL cost model: estimating the cost of flushing temp buffers to disk
Tech Optimizer
March 29, 2026

PostgreSQL cost model: estimating the cost of flushing temp buffers to disk

The project focuses on enabling temporary tables in PostgreSQL's parallel query execution by benchmarking sequential writes and reads of temporary buffers. Functions were introduced to measure buffer flush operations, and tests were conducted to estimate the cost of flushing temporary table buffer pages to disk. Findings indicate that sequential writes are about 30% slower than reads, leading to a proposed cost model. Temporary tables have limited parallel usage due to their function as relational variables and the complexity of parallel workers accessing the leader process's local state. Two enterprise PostgreSQL distributions already support parallel operations on temporary tables, and discussions on logical replication of DDL highlight the need for improved tooling for temporary tables. A significant challenge is that temporary buffer pages are local to the leader process, and if not flushed to disk, parallel workers cannot access them. A comment from 2015 suggests flushing the leader's temporary buffers to disk before parallel operations to allow workers to scan the table in parallel. However, this raises concerns about the cost of writing buffers versus the benefits of parallelism. The benchmarking toolkit includes modifications to PostgreSQL to facilitate measurement of local buffers. Two key commits added statistics infrastructure to track allocated and dirty local buffers and UI functions to manage buffer operations. The methodology involves creating a temporary table, flushing buffers, measuring I/O, and evaluating scan overhead. The tests reveal that the cost of writing a temporary table approximates the cost of a sequential page, leading to a proposed formula for flushing costs. The results show that larger buffer sizes lead to higher write overhead and increased variability. A comprehensive formula for pre-flushing temp buffers is suggested, factoring in the number of dirtied and allocated local buffers. Next steps include adding planner flags for temporary objects, implementing executor support for worker access to temporary table storage, introducing a temp-buffer flush operation, and integrating the cost model into the planner for parallel scans of temporary tables.
Mechabellum is a conversation you should be having
AppWizard
March 28, 2026

Mechabellum is a conversation you should be having

Mechabellum is an autobattler game that supports 1v1, 2v2, or 1v1v1v1 matchups, where players deploy various mechs to engage in combat. The game emphasizes strategic interaction over execution, allowing players to adapt their strategies based on their opponent's moves. After about ten hours of gameplay, players experience the game's depth, characterized by a dynamic exchange of tactics that resembles a conversation. Defeats often arise from understanding the opponent's intentions rather than from executing a pre-learned strategy. The game provides clear cause-and-effect feedback, enabling players to learn from their decisions. New units are regularly introduced, and matches are designed to be concise, fitting easily into players' schedules. The visual presentation of the game enhances the experience, making battles easy to follow and rewarding strategic planning.
Windows 11 Update Aims to Cut Upsells and Improve User Experience
Winsage
March 28, 2026

Windows 11 Update Aims to Cut Upsells and Improve User Experience

Microsoft is shifting its strategy for Windows 11 to reduce intrusive ads, upsells, and distractions based on user feedback. The company plans to scale back promotional content, particularly in the Start menu and system notifications, to create a cleaner user interface. The integration of Copilot, Microsoft's AI assistant, will be reduced in various applications to minimize distractions. Users will gain more control over updates, including the timing of installations and fewer forced restarts. Additional improvements include the ability to move the taskbar, enhanced performance and reliability, and a reduction of intrusive AI elements. Microsoft has acknowledged user criticism and is focusing on meaningful improvements in response to feedback.
Update Windows 11 will block Denuvo hacking via Hypervisor
Winsage
March 28, 2026

Update Windows 11 will block Denuvo hacking via Hypervisor

Microsoft has confirmed a major kernel security update for Windows 11, revoking trust in older drivers signed through an outdated cross-certification program. The update will ensure that Windows 11 accepts only software that has passed the Windows Hardware Compatibility Program's testing standards. This change aims to counter piracy attempts, particularly against a hacker known as DenuvOwOA, who bypassed Denuvo's anti-piracy protection by manipulating the embedded hypervisor and loading unsigned or vulnerable drivers. The new security policy will block the execution of such code, making existing hacking methods obsolete. The rollout will begin in compatibility assessment mode for Windows 11 and Windows Server & Hosting, with a hard block activated only if no stability issues are detected. Corporate clients can manually add certificates through the Application Control for business tool, while gamers will find it increasingly difficult to run hacked games relying on a modified hypervisor.
Bogus Avast website fakes virus scan, installs Venom Stealer instead
Tech Optimizer
March 27, 2026

Bogus Avast website fakes virus scan, installs Venom Stealer instead

A deceptive website impersonating Avast antivirus tricks users into downloading Venom Stealer malware, which steals passwords, session cookies, and cryptocurrency wallet information. The site conducts a fake virus scan, falsely reporting threats to encourage users to download a malicious file named Avastsystemcleaner.exe. This file mimics legitimate software and operates stealthily, targeting web browsers to harvest credentials and session cookies. It also captures screenshots and sends stolen data to the command-and-control domain app-metrics-cdn[.]com via unencrypted HTTP. The malware employs evasion techniques to avoid detection and is part of a long-standing cybercrime tactic that exploits user trust in security software. Indicators of compromise include the file hash SHA-256: ecbeaa13921dbad8028d29534c3878503f45a82a09cf27857fa4335bd1c9286d, the domain app-metrics-cdn[.]com, and the network indicator 104.21.14.89.
Fusing turn-based tactics and real-time action, Vaunted is a new strategy RPG from Starcraft creator James Phinney
AppWizard
March 26, 2026

Fusing turn-based tactics and real-time action, Vaunted is a new strategy RPG from Starcraft creator James Phinney

Vaunted is a tactical RPG from indie studio Lost Lake Games, set a millennium after the collapse of the last galactic empire, where mercenaries and treasure hunters seek priceless relics. The game combines third-person shooter action with turn-based tactical gameplay, allowing players to plan from a high-angle viewpoint while executing actions in real time. Players manage three characters—Dyse, Gendril, and Kyvaath—each with unique skills and backstories, and their choices influence the narrative. The game features dynamic combat mechanics, customizable loadouts, and randomized upgrades. Tim Bender, CEO of Hooded Horse, praises the project, and while a release date is not yet announced, players can wishlist it on Steam for updates.
Cancelled Last Of Us Game Returns In Last Way You'd Expect
AppWizard
March 26, 2026

Cancelled Last Of Us Game Returns In Last Way You’d Expect

Naughty Dog has canceled a new installment in The Last of Us franchise, shifting focus back to single-player experiences. An indie project inspired by Factions, initially called United State, has been rebranded as Terminal War, a third-person 4v4 multiplayer shooter developed by Albatross Interactive. The game captures the essence of The Last of Us and is currently available for wishlisting on Steam, with plans for a console version depending on its success. A brief gameplay clip has received positive reactions, highlighting mechanics reminiscent of the original series. The future of The Last of Us Part III remains uncertain.
Your Windows 11 File Explorer stutters because of an XP-era feature you can turn off in seconds
Winsage
March 25, 2026

Your Windows 11 File Explorer stutters because of an XP-era feature you can turn off in seconds

Windows 11's File Explorer has received mixed reviews, particularly due to delays in opening folders caused by the Automatic Folder Type Discovery feature. This feature scans folder contents to determine the best view, which can lead to frustrating delays, especially in folders with many files. Users can disable this feature through a registry edit, specifically by creating a new string value named FolderType and setting it to NotSpecified in the Registry Editor. After making this change and restarting the PC or File Explorer, the delays associated with Automatic Folder Type Discovery will be eliminated.
Pacific Drive is an excellent driving sim with horror vibes, and you can get the full experience cheaper than ever
AppWizard
March 25, 2026

Pacific Drive is an excellent driving sim with horror vibes, and you can get the full experience cheaper than ever

Pacific Drive is a game that combines eerie atmospheres reminiscent of Stalker or Chernobylite with survival mechanics in a driving simulator format. Set in the Olympic Exclusion Zone, players use vehicles to navigate supernatural events while gathering resources and upgrading their cars. The environment poses challenges such as radiation damage, requiring repairs for safe returns. The recent expansion, Whispers in the Woods, focuses on the occult practices of the zone's former inhabitants. Critics have praised the game, with a notable 9/10 review highlighting its sound design and narrative. Pacific Drive is currently available for .94 / £9.12, a 64% discount, and the Whispers Edition bundle, including the DLC, is priced at £17.99.
Search