performance optimization Archives

Tech Optimizer

May 21, 2025

Achieve up to 1.7 times higher write throughput and 1.38 times better price performance with Amazon Aurora PostgreSQL on AWS Graviton4-based R8g instances

Upgrading to Graviton4-based R8g instances with Aurora PostgreSQL-Compatible 17.4 in an Aurora I/O-Optimized cluster configuration results in significant performance improvements. The new instances provide up to 1.7 times higher write throughput, 1.38 times better price-performance, and reduce commit latency by up to 46% on r8g.16xlarge instances and 38% on r8g.2xlarge instances compared to Graviton2-based R6g instances. The Amazon Aurora PostgreSQL-Compatible Edition now supports AWS Graviton4-based R8g instances and PostgreSQL 17.4, which introduces performance enhancements for I/O-Optimized configurations, optimizing write operations and batch processing. R8g instances offer up to 192 vCPUs and 1.5 TB of memory, supporting larger configurations and providing up to 50 Gbps of network bandwidth. PostgreSQL 17 includes vacuum improvements, eliminates the need to drop logical replication slots during upgrades, and expands SQL/JSON standards. Aurora PostgreSQL-Compatible separates compute from storage, enabling independent scaling and maintaining six-way replication for durability, while processing changes as log records to reduce I/O operations. Performance benchmarks using HammerDB show improvements in throughput and commit latency across various workloads. For small workloads on 2xlarge instance size, throughput increased by 50.25% and commit latency improved by 33.87%. For medium workloads on 16xlarge instance size, throughput increased by 30% and commit latency improved by 17.44%. The most significant performance benefits arise from combining hardware upgrades from Graviton2 to Graviton4 with database engine upgrades from PostgreSQL 15.10 to 17.4. For small workloads, throughput increased by 70% and commit latency improved by 38.71%. For medium workloads, throughput increased by 70% and commit latency improved by 46.67%. Cost efficiency is also enhanced, with a 38% improvement in price performance and a 61.26% improvement in price-performance ratio when comparing Graviton2 and Graviton4 instances. Reserved Instances for Graviton4-based R8g instances offer additional cost-optimization opportunities.

Winsage

May 15, 2025

Windows 11 starts giving custom advice based on your PC hardware

A new hardware assessment feature for Windows 11 has entered the testing phase for Windows Insiders and will soon be available to all Windows 11 24H2 users. This feature can be found in the Settings app under a dedicated FAQ section on the About page. It includes expandable questions related to system performance, such as RAM capacity and GPU requirements for gaming and video editing. Users will receive tailored answers based on their specific hardware configurations, helping them determine if their setup is adequate for various tasks.

Winsage

May 11, 2025

10 Windows services I safely disable, and you can too

Windows 11 includes various background services that can be disabled to enhance performance or privacy. Users can access the Services window by searching for "Services" in the search bar. Key services that may be unnecessary for many users include: - Windows Mobile Hotspot Service: Often unnecessary as most laptops lack a mobile data connection. - Fax: Rarely needed for personal computers. - Downloaded Maps Manager: Manages downloaded maps, likely to become less relevant with the deprecation of Windows Maps. - Certificate Propagation: Essential for smart card functionality; can be disabled if not using smart cards. - Windows Insider Service: Manages enrollment in the Windows Insider program; advisable to disable if not participating. - Parental Controls: Useful for families; can be disabled if the device is for personal use. - Windows Image Acquisition: Facilitates image acquisition from scanners and cameras; can be disabled if no scanner is used. - TCP/IP NetBIOS Helper: Aids communication with local network devices; can be disabled for most home users. - Xbox Live Game Save: Syncs save data with Xbox Live; unnecessary for users who primarily use other gaming platforms. - Connected User Experiences and Telemetry: Collects diagnostic data; disabling it can enhance privacy. Disabling these services may not lead to significant performance improvements but can create a more personalized computing experience. Users can re-enable any service if needed later.

Tech Optimizer

May 5, 2025

One-click Postgres Pro optimization with pgpro_tune

pgpro_tune is a command-line utility designed to optimize the initial server configuration of Postgres Pro based on hardware specifications. It scans the server to identify key hardware details, processes these values through shell scripts that encapsulate tuning expertise, and generates recommended parameters for PostgreSQL settings, including memory management, autovacuum tuning, connection limits, and statistics collection. The utility appends these settings to the postgresql.conf file, ensuring they override the default settings. pgpro_tune supports various presets for different use cases and allows database administrators to create custom presets. It runs automatically during cluster initialization and can be executed manually at any time, applying changes through standard PostgreSQL methods. This tool aims to streamline the tuning process, reduce the risks of misconfiguration, and enhance performance without replacing the need for advanced tuning in specialized scenarios.

Winsage

April 16, 2025

I disabled these 5 Windows services to improve my PC performance

Windows operating systems have numerous background services that can consume system resources and slow down performance. Users can improve responsiveness by disabling non-essential services. 1. Windows Search: Indexes files and data for quick searches; can tax CPU and RAM. To disable: press Ctrl + R, type services.msc, locate Windows Search, stop the service, and set Startup type to Disabled or Manual. 2. SysMain (formerly Superfetch): Preloads frequently used applications into memory but can lead to unnecessary disk activity on SSDs. To disable: access services.msc, find SysMain, stop the service, and set Startup Type to Disabled. 3. Windows Update Delivery Optimization: Shares update files with other PCs, consuming bandwidth. To disable: go to Settings -> Windows Update -> Advanced Options and turn it off. 4. Remote Desktop Services: Enables remote connections, which can drain resources and pose security risks. To disable: locate Remote Desktop Services in services.msc, stop it, and set Startup type to Disabled. 5. Connected User Experiences and Telemetry: Collects usage data and can transmit sensitive information. To disable: turn off the service and navigate to Settings -> Privacy & Security -> Diagnostics & Feedback to disable Diagnostic data. Additional services that may be disabled include Print Spooler, Fax, Bluetooth Support, and Windows Error Reporting Service for further performance optimization.

Winsage

April 7, 2025

5 essential tips to optimize Windows 11 for office work

Windows 11 includes features to enhance productivity, particularly through customization for older PCs. Key strategies include: 1. Virtual Desktops: Use Win + Tab or the Task View icon to create separate virtual desktops for work, allowing for a more organized workspace. Applications can be dragged into this desktop and will reappear upon reopening. 2. Focus Sessions: Activate Focus via Settings -> System -> Focus to set timers for work sessions and breaks, enabling Do Not Disturb mode to silence notifications during work periods. 3. System Optimization: Select a High Performance power plan in Control Panel -> Power Options or Settings -> System -> Power & battery, and disable unnecessary startup apps in Task Manager to improve performance. 4. Pinning Apps and Snap Layouts: Pin frequently used applications to the taskbar for quick access and use Snap Layouts by dragging windows to the screen edges for efficient arrangement. 5. Keyboard Shortcuts: Utilize essential Windows 11 shortcuts to enhance efficiency, such as Windows key + A for Quick Settings, Windows key + E for File Explorer, and Windows key + H for voice typing.

Tech Optimizer

April 2, 2025

Improve PostgreSQL performance using the pgstattuple extension

PostgreSQL is an open-source relational database management system known for its extensibility, which allows developers to enhance its capabilities through various extensions and plugins. The pgstattuple extension provides detailed statistics at the tuple level from PostgreSQL tables and indexes, revealing key metrics such as the number of live tuples, dead tuples, average length of live tuples, total free space, and percentages of free space and dead tuples. These metrics help database administrators identify potential health and performance issues, such as excessive table bloat or index fragmentation. Both Amazon Aurora and Amazon RDS support the pgstattuple extension, which can be activated using the command CREATE EXTENSION pgstattuple;. Functions like pgstattuple(relation) and pgstatindex(index) can be used to analyze physical storage and index statistics. Bloat occurs when unused space is left behind after UPDATE and DELETE operations, and the autovacuum process in PostgreSQL automates the cleanup of dead tuples. However, if autovacuum fails, manual intervention may be necessary. Regular monitoring of bloat is essential for maintaining performance, and metrics from pgstattuple can help optimize autovacuum settings. The pg_cron extension can automate VACUUM operations to manage bloat proactively. Index bloat can also be detected using pgstatindex, and significantly bloated indexes can be rebuilt using REINDEX or pg_repack. Best practices for using pgstattuple include estimating bloat with check_postgres, analyzing physical storage, monitoring dead_tuple_percent, and avoiding interference on highly active tables.

Winsage

March 26, 2025

Download BleachBit (free) for Windows, macOS and Linux

BleachBit is an open-source system cleaning tool that helps users enhance disk capacity by removing unnecessary files and improving privacy. It permanently deletes files to prevent recovery, making it suitable for users handling sensitive information. The tool offers features such as shredding unused disk space, clearing browser histories, and removing software logs. BleachBit is free to use, lightweight, and compatible with various operating systems, including Windows, Linux, and macOS (with limited functionality). It supports cleaning for multiple applications and provides command-line functionality for advanced users. Additionally, BleachBit can be run from a USB drive without installation. Alternatives to BleachBit include CCleaner, Advanced SystemCare, and DaisyDisk, each offering different functionalities and features.

Winsage

March 19, 2025

Leaked Windows 11 feature explains why your PC hardware struggles

Windows 11 is developing a new FAQ section in the Settings app that provides advice on optimizing system performance. This section, currently hidden and accessible via command line, includes guidance on whether a GPU is sufficient for high-end gaming, recommending a discrete graphics card with more than 4GB of RAM. It also states that 4-8GB of RAM is adequate for basic tasks like web browsing and document editing. Microsoft has not officially commented on this feature, and it remains unclear if it will be included in the next major update or only appear when hardware limitations are detected.

BetaBeacon

March 14, 2025

Google levels up Android graphics with Vulkan API in time for GDC 2025

Diablo Immortal is running on Vulkan, which helps optimize graphics for a smooth and engaging experience for players.