Performance Improvements Archives

Tech Optimizer

July 22, 2025

PostgreSQL services from hyperscalers raise downtime conerns

Recent research shows that 82 percent of PostgreSQL users are concerned about cloud region failures, with 21 percent experiencing such failures in the past year. In the first half of 2025, PostgreSQL gained over 13 points in database popularity rankings, becoming the fourth most popular database. A survey found that 91 percent of organizations using PostgreSQL expect no more than four minutes of downtime per month, with 24 percent aiming for less than 30 seconds. Microsoft Azure, AWS, and Google offer various PostgreSQL services, while alternatives like CockroachDB and YugabyteDB focus on reliability. PlanetScale recently launched a PostgreSQL service that is 100 percent compatible with open-source PostgreSQL. Convex is transitioning from AWS Aurora to PlanetScale for better performance. pgEdge offers a multi-master distributed database for high availability. AWS claims its Amazon Aurora DSQL is designed for up to 99.999 percent availability, while its Aurora for PostgreSQL guarantees 99.99 percent uptime.

Winsage

July 12, 2025

Windows 11 Build 27898 introduces taskbar icon scaling and system recovery improvements

Microsoft has released Windows 11 Insider Preview Build 27898 to the Canary Channel, introducing several new features aimed at enhancing usability and recovery. Key features include: - Taskbar Icon Scaling: The taskbar will automatically reduce icon sizes when it reaches capacity, with three customizable options for users regarding icon size. - Quick Machine Recovery: This feature allows automatic recovery from boot issues using the Windows Recovery Environment (WinRE), connecting to the internet for targeted fixes from Windows Update. - Accessibility Enhancements: Users can add custom words to the voice access dictionary, and a new Screen Curtain feature for the Narrator screen reader enhances privacy by blacking out the display. - Energy Saver Feature: An adaptive energy saver mode is being rolled out for battery-powered devices, managing energy saver settings based on power state and system load. - Sharing Features: The Windows share window now shows visual previews of shared content and allows users to select compression settings for images. - Performance Improvements: Enhancements have been made to file extraction for large archives, and the Snipping Tool now has a shortcut for launching the text extractor. - Default Browser Management: Users can set their default browser to handle PDFs and pin it to the Start menu and taskbar. The build also addresses various issues within File Explorer and Settings, although some known problems remain, such as display distortion in Remote Desktop on Arm64 PCs.

Winsage

July 11, 2025

Announcing Windows 11 Insider Preview Build 27898 (Canary Channel)

Windows 11 Insider Preview Build 27898 has been released to the Canary Channel. Key features include: - Taskbar Icon Scaling: Icons on the taskbar can automatically resize when the taskbar is full, with options to keep them at original size or always small. - Quick Machine Recovery: This feature identifies and resolves common issues automatically via the Windows Recovery Environment, reducing downtime. - Custom Words in Voice Access: Users can add custom words to the voice access dictionary to improve dictation accuracy. - Screen Curtain in Narrator: This feature blacks out the display for privacy while using Narrator. - Privacy Dialogs Update: Privacy dialogs for app permissions have been redesigned for better focus. - Accessibility Enhancements: Text descriptions for assistive technologies have been added to the Accessibility flyout. - File Explorer Improvements: Dividers have been added to the context menu for better organization. - Adaptive Energy Saver: An opt-in feature that manages energy saver settings based on power state and system load. - Windows Share Updates: Visual previews are now shown when sharing links or web content. - Expanded Voice Access Support: Voice access now supports Simplified Chinese, Traditional Chinese, and Japanese. - Narrator Guidance: Narrator will guide users through its features with modal windows. - Settings Adjustments: The selected country or region during setup is now displayed in Settings. Fixes include performance improvements in File Explorer, resolution of input issues with the touch keyboard, and fixes for crashes in Settings. Known issues involve potential loss of Windows Hello PIN on new Copilot+ PCs and graphical issues with Remote Desktop on Arm64 PCs.

Tech Optimizer

July 8, 2025

How TimescaleDB helped us scale analytics and reporting

At Cloudflare, PostgreSQL and ClickHouse are used as primary databases for transactional and analytical workloads. PostgreSQL is preferred for product development due to its speed, versatility, and reliability, with hundreds of instances running in various configurations. ClickHouse, introduced in 2017, allows ingestion of tens of millions of rows per second with millisecond-level query performance but comes with trade-offs. The Digital Experience Monitoring (DEX) product was developed with a focus on simplicity and rapid shipping, utilizing a team of three engineers and collaboration with other teams. DEX's initial launch included fleet status logs uploaded every two minutes and synthetic tests with usage caps, leading to a successful MVP launch ahead of schedule. The architecture included an HTTP API, PostgreSQL for storing configurations, and a React UI in the Cloudflare Dashboard. PostgreSQL was chosen for analytics due to its ability to handle structured logs, with a table created for device state logs lacking a primary key but optimized with unique and standard indexes for common queries. The UPSERT query was used for data insertion, and the order of columns in multicolumn indexes was optimized for performance. After launching DEX, the system scaled to 1,000 inserts per second, leading to performance degradation. Precomputed aggregates were implemented to improve query performance, resulting in up to a 1000x improvement. Table partitioning was considered but ultimately not pursued due to its manual management requirements. TimescaleDB was explored as an alternative to enhance query performance, offering features like automatic partition management, continuous aggregates, and compression. A side-by-side comparison with PostgreSQL showed significant performance improvements, particularly for longer time windows. TimescaleDB's integration allowed for efficient data retention and aggregation, simplifying the infrastructure. Following the success of DEX, other teams at Cloudflare began using TimescaleDB for analytics and reporting, consolidating data from various sources and managing high ingestion rates effectively by optimizing data handling techniques such as switching to COPY for bulk inserts and adjusting replication settings.

Winsage

July 8, 2025

Microsoft Edge UI Now 40% Faster on Average, Key UI Elements Load Up to 4x Quicker

Microsoft has updated its Edge browser, achieving a First Contentful Paint (FCP) of under 300 milliseconds by using its WebUI 2.0 architecture instead of the traditional React framework, resulting in a 40% average reduction in load times for thirteen core features. The updated settings UI shows a fourfold improvement in performance compared to the previous version. This release builds on enhancements from May 2024, which improved launch times by 42-76%, and an optimization effort in February 2025 that targeted fourteen interface subsystems. Internal tests confirm the settings panel now consistently renders in under 300 ms. Microsoft plans to extend these performance improvements to Print Preview and Extensions management throughout 2025.

Winsage

July 8, 2025

Microsoft’s Edge browser now loads sites even faster

Microsoft has announced significant enhancements to the Edge browser, achieving a First Contentful Paint (FCP) of under 300 milliseconds, which improves user interface responsiveness. This performance metric indicates that the browser can display initial website elements in less than 300 milliseconds. Microsoft emphasizes that waiting longer than 300 to 400 milliseconds can negatively affect user satisfaction. Edge currently holds less than five percent of the global browser market share, while Chrome has 68 percent. Recent upgrades include faster downloads, browsing history, and private tabs, with improvements to 13 additional features. Microsoft plans to introduce further performance enhancements targeting Print Preview and Extensions in the coming months.

Winsage

July 5, 2025

Windows 11 has finally overtaken Windows 10 in worldwide market share after nearly four years

Windows 11 has officially surpassed Windows 10 to become the most popular Microsoft operating system globally. This shift occurs as Windows 10 approaches its end-of-life date this October, leading to a decline in its user base. Data from StatCounter indicates that while Windows 10 had a stable user count for several months, its share has recently decreased significantly, prompting users to transition to Windows 11. Despite the availability of free options for extending Windows 10 security support, many users have chosen to upgrade to Windows 11, reflecting growing confidence in its capabilities. Windows currently holds a collective market share of 70.14%, compared to OS X at 9.87% and both Linux and macOS around 5%.

Winsage

July 5, 2025

Upgrade to Windows 11 and DOUBLE performance? PCs powered by new software are 2x faster than Windows 10

Microsoft claims that laptops and desktop PCs running Windows 11 are "up to 2.3x faster than Windows 10 PCs." Windows 10, the most widely used desktop operating system, powers over 1 billion devices but will stop receiving free updates after October 14, 2025. Users can pay £22 for an additional year of support. The performance comparison is based on Geekbench 6 benchmarks, contrasting new Windows 11 devices with older Windows 10 systems. Between May and June 2025, Windows 11 usage increased by over 4%. Microsoft plans to release Windows 11 Version 25H2 later this year, which will feature a redesigned Start menu and a new CPU throttling feature. Users eligible for a free upgrade can benefit from a smoother installation process. Microsoft offers free security updates to Windows 10 users who subscribe to OneDrive; otherwise, the £22 fee applies. Some users may be hesitant to upgrade due to Windows 10's superior gaming performance in certain scenarios.

Winsage

July 4, 2025

Microsoft’s extra year of Windows 10 security updates isn’t a “viable solution” for the 400 million PCs that can’t upgrade to Windows 11 — “It’s obvious users are frustrated and feel yanked around.”

Windows 10 will reach its end-of-life support on October 14, 2025, prompting backlash from users and a petition from the Public Interest Research Group (PIRG) urging Microsoft to reconsider its decision. Microsoft will provide free security updates beyond the end-of-life date, but only under specific conditions, leading to concerns about accessibility due to stringent system requirements. PIRG argues that the updates will not sufficiently address the needs of the estimated 400 million Windows 10 PCs unable to upgrade to Windows 11. Users have limited options, including syncing settings to the cloud, redeeming Microsoft Reward points, or paying for extended security updates (ESU). While Microsoft has made some concessions, such as offering ESU for individuals and affordable pricing for educational institutions, it has not committed to extending Windows 10 support or easing Windows 11's hardware requirements. Windows 11 is gaining market share, reaching 47.73% in June, while Windows 10 holds 48.92%. Microsoft is promoting Windows 11 and its AI-enhanced features, claiming significant performance improvements. Additionally, a movement called End of 10 is encouraging users to switch to Linux as Windows 10's end-of-life approaches, highlighting benefits like the absence of ads and telemetry tracking.

Winsage

July 2, 2025

I made 21 tweaks in Windows 11 to increase gaming performance

Windows 11 provides several adjustments to enhance gaming performance, including: 1. Enable Game Mode: Prioritizes gaming processes. 2. Disable Memory Integrity: Can improve performance during gaming. 3. Disable Virtual Machine Platform: Turns off virtualization for better performance. 4. Change Power Mode: Set to "High Performance" for maximum resource allocation. 5. Enable Auto HDR: Enhances visuals for HDR-capable displays. 6. Enable Automatic Super Resolution: Upscales games using AI for better frame rates and image quality. 7. Change Game Default GPU: Set a specific GPU for individual games. 8. Install Games on Secondary Drive: Improves loading times, especially with SSDs. 9. Optimization for Windowed Games: Reduces input latency for windowed mode games. 10. Change Refresh Rate: Adjust to the highest available for smoother gameplay. 11. Disable Apps at Startup: Frees up system resources by minimizing startup applications. 12. Free Up Storage Space: Enhances system speed and gaming performance. 13. Install System Updates: Resolves performance issues and improves compatibility. 14. Update Graphic Drivers: Ensures optimal performance in games. 15. Debloat Setup: Uninstall unnecessary applications to free up resources. 16. Enable GPU Scheduling: Reduces latency by offloading tasks from the CPU. 17. Use DirectStorage: Allows faster asset loading from NVMe SSDs. 18. Enable Variable Refresh Rate: Synchronizes refresh rate with frame rate to reduce screen tearing. 19. Change Settings in Games: Adjust in-game settings for optimal performance. 20. Reset Your Computer: Restores system to optimal performance if issues persist.