NewApp Digest
search bot

performance optimizations

PostgreSQL 18: Part 2 or CommitFest 2024-09
Tech Optimizer
February 21, 2025

PostgreSQL 18: Part 2 or CommitFest 2024-09

September's CommitFest for version 18 has seen a wealth of accepted patches and new features, including: - Conflict detection and logging in logical replication - Removal of the constant 10000000000 in the planner to improve sequential scan cost assessment - Enhanced memory management and usage monitoring for temporary tuple storage - Asynchronous operations support in pg_upgrade for multiple databases - Speed improvements for Hash Joins - Faster text value processing in JSON - Optimized numeric-type multiplication and division - Introduction of ANALYZE ONLY and VACUUM ONLY commands - Improved checkpointer statistics - Normalization of SET commands in pg_stat_statements - Reporting of remote connection status in postgres_fdw_get_connections - Ignoring format conversion errors in file_fdw - New function has_largeobject_privilege - Functions crc32 and crc32c added - Client-server protocol updates to report search_path changes - Support for named prepared statements in psql - Integrity verification for tar backups in pg_verifybackup
Ubisoft Releases Assassin's Creed Shadows PC & New-Gen Features Trailer
AppWizard
February 14, 2025

Ubisoft Releases Assassin’s Creed Shadows PC & New-Gen Features Trailer

Ubisoft has announced that Assassin’s Creed Shadows will be released on March 20, 2025, for PlayStation 5, Xbox Series X|S, and PC, set in 16th-century feudal Japan. The game features two protagonists: Yasuke, a historical African samurai, and Naoe, a skilled shinobi. It will not be available on older consoles like PlayStation 4 and Xbox One. Key features include uncapped frame rates on PC, multiple performance modes on consoles, ray tracing, AI-driven upscaling techniques, and spatial audio technology. The game is powered by the new Anvil engine, designed exclusively for current-generation hardware, and will run at 60 FPS on consoles. Minimum and recommended system requirements for PC have been specified, and the game requires a constant internet connection for activation and online features. Pre-orders are open with multiple editions available.
Marvel's Spider-Man 2 receives first full patch for PC after problems at launch
AppWizard
February 7, 2025

Marvel’s Spider-Man 2 receives first full patch for PC after problems at launch

Marvel's Spider-Man 2 was released on PC on January 30 and faced technical issues leading to mixed reviews on Steam. A major patch was released to address these problems, which included: - Resolution of multiple crash triggers based on player feedback and crash data. - Enhancement of the crash reporting system with screenshot support. - Addition of an option to toggle between Film Style Animation and Comic SFX in settings. - Revamping of the interface for easier initiation of New Game+ mode. - Implementation of a backup system for autosaves at critical narrative points. - Enabling mouse scrolling in the manual load/save menu. - Correction of visual and interface glitches related to DLSS Ray Reconstruction and ray tracing. The developers acknowledged that not all issues were resolved but committed to ongoing updates for further improvements.
Spider-Man 2's first PC patch is live with 'several crash fixes,' UI improvements, and an auto-save backup
AppWizard
February 6, 2025

Spider-Man 2’s first PC patch is live with ‘several crash fixes,’ UI improvements, and an auto-save backup

Spider-Man 2 has received its first substantial patch aimed at addressing crash issues and bugs after a challenging debut with a "mixed" user rating on Steam. The patch includes various crash fixes based on player feedback, improvements to crash reporting, user interface enhancements, and new features such as toggling Film Style Animation and Comic SFX. Additionally, it implements autosave backups, adds mouse scrolling to the manual load/save menu, and reduces noise in character hair when using DLSS Ray Reconstruction. Other fixes include resolving a bug related to ray-traced reflections and ensuring that settings for Subtitle Text Size and other options are no longer synchronized between devices. Players are encouraged to keep their GPU drivers updated and contact Nixxes support for ongoing performance issues.
7 GitHub Open Source You Need to See
Tech Optimizer
December 16, 2024

7 GitHub Open Source You Need to See

Open-source tools are enhancing productivity and streamlining processes for developers and organizations. Notable projects include: - **Olshansk/postgres_for_everything**: Extends PostgreSQL's capabilities with resources for JSON/JSONB types, TimescaleDB for time-series data, full-text search, pgRouting for graph data, and advanced SQL analytics. - **Biggest Shell Programs in the World**: Analyzes large shell scripts and systems, including the Linux Kernel Build System, Android Build System, and Debian Packaging Tools. - **Pulumi**: An infrastructure-as-code platform that allows management of cloud infrastructure using languages like Python, JavaScript, and Go, with features like multi-cloud support and Kubernetes integration. - **yorukot/superfile**: A Python library for file operations, offering high-level methods for file handling and cross-platform compatibility. - **soci-snapshotter**: An AWS Labs project for optimizing container image management through lazy loading and snapshotting technology. - **Spark UI**: Enhances management and monitoring of Apache Spark applications with live metrics, interactive visualizations, and integration with event logs. - **LFI.dev**: A framework for developing real-time collaborative web applications with offline functionality and synchronization. - **WrenAI**: A tool for creating intelligent chatbots and virtual assistants with prebuilt NLU and NLG capabilities. - **Astro 5.0**: A framework for building content-focused websites with server-side rendering, static site generation, and improved Markdown handling. - **Outerbase Studio**: An open-source database management tool with a browser-accessible UI and compatibility with various relational databases. - **Undici**: A high-performance HTTP client for Node.js, featuring advanced connection pooling, a promise-based interface, and support for streaming requests.
Cyberpunk 2077's surprise new update lets Keanu ride shotgun through the streets of Night City and makes some PC-specific improvements—and it's out now
AppWizard
December 10, 2024

Cyberpunk 2077’s surprise new update lets Keanu ride shotgun through the streets of Night City and makes some PC-specific improvements—and it’s out now

CD Projekt has released the Cyberpunk 2077 2.2 update, which includes new features for vehicle customization and photo mode enhancements. The update introduces a color-changing CrystalCoat system for various vehicles, allowing players to customize their cars. The TwinTone system enables players to scan and save vehicle color schemes. Photo mode improvements include a free drone camera, increased camera range, full collision options, a lock camera feature, precise camera control, custom aspect ratios for PC screenshots, a characters tab for spawning NPCs, adjustable lighting, a depth of field fix, and an effect intensity slider. New character customization options are available, and players are encouraged to explore Night City for hidden secrets. The update also includes quest adjustments, bug fixes, and gameplay tweaks, such as fixes for katana animations and HUD visibility issues. Phantom Liberty-specific updates address various quest-related bugs. Miscellaneous fixes include sound adjustments, voiceover corrections, and ray-traced shadow improvements. PC-specific enhancements allow for key rebinding and performance optimizations.
Here are the new features Microsoft Store received in 2024
Winsage
December 4, 2024

Here are the new features Microsoft Store received in 2024

Throughout 2024, the Microsoft Store app on Windows 11 and 10 has undergone significant updates, including: - A revamped Library section divided into Update and Library categories, with a search bar for easier navigation. - Enhanced product listings featuring a new install progress bar that shows app size and completion percentage, improved gaming categories, and automatic trailers on product pages. - Performance optimizations resulting in a 25% reduction in launch time and a 50% decrease in failed downloads. - Additional features such as a revamped web installation experience, support for Win32 app web installers, and improved search and recommendation features. - The annual Microsoft Store App Awards showcased popular applications like ChatGPT, Arc, and Fantastical.
Search