test Archives

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.

Tech Optimizer

May 19, 2025

How to catch and optimize problematic queries in PostgreSQL

Performance issues in PostgreSQL can arise as databases grow, leading to declines in query performance. To identify problematic queries, one can log long-running queries by setting the `log_min_duration_statement` parameter in the `postgresql.conf` file. The `pg_stat_statements` module can be enabled to monitor execution statistics of SQL statements, providing insights into query performance, including execution time and the number of calls. Queries with high standard deviation in execution time may indicate inconsistency, while sorting query statistics by total execution time can reveal excessive load from multiple fast queries. Real-time monitoring can be done using the `pg_stat_activity` view to check active queries and their states, and the `pg_locks` view can help identify blocked processes. The `EXPLAIN` command can analyze query execution plans, and using the `auto_explain` module can log plans for slow queries. Understanding cost parameters in query plans helps in optimizing performance, and different join methods (Nested Loop, Merge Join, Hash Join) have varying complexities and costs. To influence the planner's choice of scanning methods, configuration parameters can be adjusted, such as disabling sequential scanning. Extensions like `sr_plan`, `pg_hint_plan`, and `AQO` can further optimize query execution. Monitoring query progress can be done using dynamic views like `pg_stat_progress_*` for various commands.

Tech Optimizer

May 17, 2025

Do You Really Need Antivirus on Windows 11? Probably Not—Here’s Why

Windows 11 has robust built-in security features that may reduce the need for third-party antivirus software. Windows Security now offers comprehensive protection, including real-time malware detection, firewall protection, SmartScreen alerts, hardware-level security, account monitoring, and system health reports. According to AV-TEST results from January and February 2025, Microsoft Defender Antivirus scored 6.0/6.0 in protection, performance, and usability, effectively stopping advanced malware and phishing attempts with minimal system resource usage. Users of Microsoft Edge benefit from SmartScreen filtering, while those using other browsers receive system notifications for network protection. Basic digital hygiene practices, such as avoiding suspicious downloads and keeping software updated, are crucial for security. Third-party antivirus solutions may offer additional features but can lead to performance issues and privacy concerns. For casual users who maintain their systems and practice safe browsing, Windows Security is generally sufficient, while those handling sensitive information or needing advanced features may consider premium antivirus options.

AppWizard

May 17, 2025

PlayStation 5, Xbox X/S, PC, Switch video games to play this week. Release dates, system requirements

This week, three new video games are being released: "Deliver At All Costs," "Duck Detective: The Ghost of Glamping," and "Doom: The Dark Ages." "Deliver At All Costs" features Winston Green, a courier in 1950s America, and will be available on May 22 for PlayStation 5, Xbox X/S, and PC. "Duck Detective: The Ghost of Glamping," starring gumshoe Eugene McQuacklin, also launches on May 22 for PlayStation 5, Xbox X/S, Switch, and PC. "Doom: The Dark Ages," part of the iconic Doom series, allows players to control the Doom Slayer in a quasi-medieval setting and is available starting May 15 on Xbox X/S, PlayStation 5, and PC. All games can be played on PlayStation 5, Xbox X/S, PC, and Switch.

Tech Optimizer

May 16, 2025

Best antivirus software for Windows 2025, tried and tested

Antivirus software has been a common tool for PC users over the past two decades, with many opting for third-party solutions for enhanced protection despite Windows 11's built-in features. User behavior significantly impacts computer security, emphasizing the importance of avoiding unknown links and not reusing passwords. Antivirus packages are designed to combat threats like ransomware, spyware, and viruses. The evaluation process for antivirus applications involved testing on a Windows 11 PC with simulated virus attacks and scanning the SSD for performance metrics. The top antivirus apps for 2025 include BitDefender Total Security (£49.99), Avira Free (free), Malwarebytes Plus (£49.99), and Sophos Home Premium (£37.46).

Winsage

May 16, 2025

Microsoft just fixed a 9-month-old Windows bug, which is why it’s the perfect time to try Linux

Microsoft has fixed a long-standing bug in Windows 11 that affected dual-booting with Linux, which had persisted since August 2024. The issue arose from a Secure Boot Advanced Targeting (SBAT) setting introduced in a Windows 11 update, which inadvertently disrupted dual-boot configurations by incorrectly applying the SBAT value on certain devices. As of May 2, with the release of Windows 11 version 24H2, users can now successfully dual-boot between Windows 11 and other operating systems, including Linux.

Winsage

May 16, 2025

Windows 10 KB5058379 update triggering BitLocker Recovery after install

The Windows 10 KB5058379 cumulative update, released on May 13, 2025, has caused unexpected BitLocker recovery prompts for some users after installation and reboot. Reports indicate that affected devices, including those from Lenovo, Dell, and HP, automatically boot into the Windows Recovery Environment and display the BitLocker recovery screen. Users have experienced various issues, such as needing BitLocker keys to start up or devices refusing to start. A workaround involves disabling Intel Trusted Execution Technology (TXT) in the BIOS. Microsoft has not publicly acknowledged the issue but support representatives are aware and working on a resolution. Microsoft has provided steps to resolve the issue, including disabling Secure Boot and virtualization technologies, checking Microsoft Defender System Guard Firmware Protection status, and disabling firmware protection via Group Policy or Registry Editor.

Winsage

May 15, 2025

Microsoft App Assure helps Nord Security build for Windows on Arm

Developers are focusing on optimizing applications for the newly launched Copilot+ PCs, which feature advanced system architecture, all-day battery life, and the ability to run AI models directly on the device. The initial Copilot+ PCs are powered by Snapdragon X Elite and X Plus silicon, with AMD and Intel also introducing compatible processors. Microsoft’s App Assure Program provides guidance and technical support to help developers optimize applications for these devices, particularly for Arm-based Snapdragon X Series devices. NordVPN is a notable example of a company that successfully utilized the App Assure program to develop an Arm-optimized version of their application. The program includes the Arm Advisory Service, which allows developers to consult with Microsoft engineers for a smoother development process. Other companies, such as Proton VPN and F-Secure, have also benefited from the App Assure team in optimizing their applications for the Windows on Arm platform.

Tech Optimizer

May 15, 2025

Databricks to Acquire Neon in USD 1 Billion Deal to Power AI Agent Workflows with Serverless Postgres

Databricks intends to acquire Neon, a cloud-based serverless Postgres platform, for approximately USD 1 billion. Neon, founded in 2021, offers a managed, open-source Postgres service with features like effortless database cloning, isolated environment testing, and point-in-time data restoration. Over 80% of databases on Neon are created by AI agents. The acquisition aims to enhance Databricks' infrastructure for AI-native applications, allowing developers to create isolated Postgres instances quickly and decouple compute and storage resources. Neon has raised USD 129.5 million from investors, while Databricks has secured over USD 19 billion in funding, with a valuation of USD 62 billion. The acquisition is subject to regulatory approvals, and Neon's team will join Databricks post-acquisition.

Tech Optimizer

May 14, 2025

Databricks to Acquire Neon, Targeting Serverless Postgres for AI Agent Workloads

Databricks plans to acquire Neon, a serverless Postgres provider designed for automation and AI-driven database interactions. Neon's architecture allows for 80% of databases on its platform to be provisioned automatically by AI agents, enabling rapid execution and unpredictable scaling. It can provision fully isolated Postgres instances in under 500 milliseconds and features instant schema and data forking. Neon's usage-based pricing model charges organizations only for executed queries, addressing cost inefficiencies of traditional databases. It is fully compatible with Postgres and supports common extensions, facilitating ease of use for developers. After the acquisition, Neon's team will join Databricks to support existing users and develop tools for AI-native systems.