TPM 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 21, 2025

Windows 11 Pro may be the most underrated PC gaming upgrade ever at $15

Windows 11 Pro is available for .97 until June 1, marking its lowest price ever (regularly priced at 9). It offers features like DirectX 12 Ultimate for enhanced gaming performance, Windows Copilot for AI assistance, and robust security features including BitLocker encryption and secure boot. Additional features include Snap Layouts, Virtual Desktops, Remote Desktop Access, Hyper-V, and Microsoft Teams integration.

Tech Optimizer

May 20, 2025

Running I/O intensive workloads on PostgreSQL with Amazon EBS io2 Block Express

Databases are essential for organizations, and their performance is critical to user experience and operational efficiency. AWS introduced Amazon Elastic Block Store (Amazon EBS) io2 Block Express in December 2020 to address performance issues related to storage latency during database operations. This solution enhances storage management for high-performance database servers, supporting up to 256,000 IOPS and 4,000 MiB/s throughput per volume, with a maximum volume size of 64 TiB and sub-millisecond disk I/O latency. A performance comparison was conducted between PostgreSQL databases on Amazon EBS gp3 and io2 Block Express, utilizing the HammerDB benchmarking tool. The analysis involved four tests: OLTP Load test, OLTP Stress test, OLAP Load test, and OLAP Stress test, using r5b.24xlarge EC2 instances. Results indicated that io2 Block Express outperformed gp3 by 2.08 times in transactions per minute (TPM) and provided significantly lower latency for both OLTP and OLAP workloads. Key differences between gp3 and io2 Block Express include durability, with io2 offering 99.999% durability compared to gp3's 99.8% – 99.9%. The maximum IOPS for gp3 is 16,000, while io2 supports up to 64,000 IOPS. Pricing for gp3 is approximately ,375.36/month, while io2 Block Express costs around ,408/month, reflecting its premium performance capabilities. In benchmarking tests, io2 Block Express demonstrated superior performance, achieving 3.95 times faster average performance than gp3 across all scenarios. It is particularly suitable for mission-critical applications requiring consistent sub-millisecond latency and high durability.

Winsage

May 17, 2025

Windows 11 Home vs Pro for Gaming: Which One Should You Choose?

Upgrading from Windows 11 Home to Windows 11 Pro does not yield significant benefits in gaming performance, compatibility, or features for most gamers. Both editions provide identical gaming performance, supporting the same core gaming technologies such as DirectStorage, Auto HDR, and Game Mode. Windows 11 Home supports up to 128 GB of RAM and one CPU socket with 64 cores, while Windows 11 Pro supports up to 2 TB of RAM and two CPU sockets with 128 cores. Pro includes additional features like BitLocker encryption, Remote Desktop hosting, Hyper-V virtualization, and Group Policy management, which are not typically utilized by gamers. The price of Windows 11 Home is lower than that of Pro, making it a more cost-effective choice for gaming. Both editions meet the hardware requirements for modern gaming, and compatibility with major games and platforms is consistent across both versions.

Winsage

May 16, 2025

Microsoft confirms May Windows 10 updates trigger BitLocker recovery

Microsoft has acknowledged an issue affecting some Windows 10 and Windows 10 Enterprise LTSC 2021 systems after the installation of the May 2025 security update (KB5058379), causing devices to boot into BitLocker recovery mode. This problem arises when the update leads to multiple startup failures, preventing the system from initiating Automatic Repair without the recovery key. Users experiencing this issue may see LSASS errors and the 0x800F0845 error code in the Windows Event Viewer. Reports indicate that various devices from manufacturers like Lenovo, Dell, and HP are affected. Microsoft suggests troubleshooting steps such as disabling Intel Trusted Execution Technology, Secure Boot, Virtualization Technologies, or Firmware Protection. This is not the first occurrence of such issues, as similar problems were reported after previous updates in August 2024 and August 2022.

Winsage

May 15, 2025

Microsoft Copilot+ Recall: who should disable it, and how

Microsoft's Recall feature for Copilot+ PCs was initially announced a year ago but delayed due to privacy concerns raised by cybersecurity experts. The updated version was released in April 2025 for Windows Insider Preview builds and rolled out more broadly in May. Key updates include requiring user permission for activation, encrypting database files with hardware-based Trusted Platform Module (TPM), and implementing a filter to prevent saving sensitive information. Recall is enabled on a per-user basis, can be uninstalled, does not require a Microsoft account, and processes data locally. However, it still has vulnerabilities, such as allowing access with a regular Windows PIN after initial biometric authentication and failing to consistently filter sensitive data. Recall can log interactions during calls and capture self-destructing messages, posing privacy risks. It can impact performance and battery life, especially during gaming. Users handling sensitive data or frequently using video conferencing may want to disable or remove Recall. Instructions for disabling or removing Recall are provided, along with precautions for those who choose to use it.

Winsage

May 15, 2025

Only one person at Microsoft is talking about Windows 12 — let’s keep it that way

Microsoft has not made any formal announcement regarding the release of Windows 12. The end-of-support date for Windows 11 is October 14, 2025. Historically, Windows releases have followed a pattern where every alternate version is perceived as inferior: Windows 95 (good), Windows 98 (bad), Windows 98 SE (good), Windows ME (bad), Windows XP (good), Windows Vista (bad), Windows 7 (good), Windows 8 (bad), Windows 10 (good), and Windows 11 (bad). If Windows 12 is released, it is expected to have increased hardware demands and may heavily rely on artificial intelligence, potentially leaving users with outdated hardware.

Winsage

May 15, 2025

3 reasons Windows 11 is the best advertisement Linux ever had

Windows 11 requires TPM 2.0 support for installation, creating compatibility issues for users with older hardware, even if the hardware is otherwise capable of running the OS. Many users are still on Windows 10 as the support deadline approaches, with some considering Linux as an alternative since it does not impose TPM 2.0 restrictions. Linux distributions can be installed on machines lacking TPM 2.0, allowing users to retain their existing hardware. Older CPUs, typically from Intel's 7th generation or earlier, are often incompatible with Windows 11 but can run Linux efficiently, sometimes improving application performance. Linux offers more customization and less bloat compared to Windows, appealing to users frustrated with Windows 11's limitations. The shift to Windows 11 has prompted some users to explore Linux as a viable alternative.

Winsage

May 15, 2025

Your gaming PC is overdue for an upgrade—Windows 11 Pro can fix that

Microsoft will stop providing security updates for Windows 10 on October 14, 2025. A Windows 11 Pro license is currently available for .97 until June 1 at 11:59 PM, requiring no subscription. Windows 11 Pro offers enhanced security, performance, and features, including DirectX 12 Ultimate for improved gaming, Snap layouts, virtual desktops, AI-enhanced voice typing, and Copilot powered by GPT-4 Turbo. It also includes security features like TPM 2.0, Smart App Control, and biometric login.

Winsage

May 12, 2025

Upgrade your PC’s operating system to Windows 11 Pro for $15

Microsoft is ending support for Windows 10 and encouraging users to upgrade to Windows 11 Pro, which is currently available for .97, down from 9. This offer is time-sensitive with a limited number of codes available. Windows 11 Pro enhances PC performance, features a redesigned user interface, and introduces productivity tools like snap layouts and improved search functionality. It also includes advanced security measures such as Smart App Control, TPM 2.0, and BitLocker encryption, as well as gaming enhancements through DirectX12 Ultimate. Additionally, it offers professional tools for remote work, including remote desktop access and features like Azure AD and Hyper-V.