documentation Archives

Tech Optimizer

January 29, 2026

Using Windows 10? Do This Now to Lower Your Risk of Being Hacked

Support for Windows 10 officially ended last year, and Microsoft recommends users transition to Windows 11 or buy new computers. Users will no longer receive security updates, and any issues encountered will not be supported by Microsoft. Windows Update will indicate that devices are no longer receiving updates, leaving users to manage security vulnerabilities themselves. Microsoft Defender Antivirus will continue to receive updates until October 2028, and users can enroll in Extended Security Updates (ESU) for an additional year of security updates until October 13, 2026, under certain conditions. Windows 11 installations surpassed Windows 10 in June 2025, with Windows 11 at 53.7% and Windows 10 at 42.7%. Users opting to stay on Windows 10 should implement third-party security solutions to mitigate risks from the lack of official updates.

Tech Optimizer

January 29, 2026

Aurora PostgreSQL 13 Deadline: Four Upgrade Paths to Beat February Cutoff

Standard support for Amazon Aurora PostgreSQL-Compatible Edition and Amazon RDS for PostgreSQL version 13 will end on February 28, 2026. PostgreSQL 13 will be deprecated by the community in November 2025, ceasing to receive bug fixes or security patches. AWS recommends upgrading to newer versions, such as 16 or 17, which offer significant performance enhancements and improved security. PostgreSQL 17 can achieve up to twice the write throughput and consumes 20 times less memory during vacuum operations. Version 16 introduces pg_stat_io for detailed I/O statistics, while version 14 includes a vacuum emergency mode. Aurora-specific enhancements in version 14.9 and later can lead to faster query latency and reduced costs. Version 14 introduces new roles for access control, and version 15 revokes certain permissions. Major upgrades in logical replication include automatic slot synchronization in version 17 and support for parallel apply in version 16. Transitioning between major versions requires careful examination of catalog changes, as some views and configuration parameters will evolve. Extensions must be verified, as most do not auto-upgrade. An in-place major version upgrade can be performed via the AWS Console or CLI, with downtime varying based on database size. AWS recommends snapshot-based testing beforehand. The CLI command can check valid upgrade targets, leading from version 13 to 14, 15, 16, or 17. Preparation involves validating instance classes and dropping replication slots. Amazon RDS Blue/Green deployments allow for near-zero downtime by synchronizing production with a staging environment, enabling application testing before traffic switching. This feature is supported from Aurora PostgreSQL version 13.12 onward. Logical replication through pglogical offers flexibility for minimal downtime, while AWS DMS supports homogeneous migration with Change Data Capture. Extended Support is available for a fee, providing up to three years of security patches. Best practices include replicating production environments in staging, conducting load tests, and validating queries against new catalogs. Recent minor releases, including Aurora PostgreSQL 17.6 and 16.10, showcase ongoing improvements. Engaging AWS Support is advisable for complex setups to ensure seamless transitions before the deadline.

Tech Optimizer

January 28, 2026

Strategies for upgrading Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL from version 13

Standard support for PostgreSQL version 13 will end on February 28, 2026. Upgrading to newer PostgreSQL versions can enhance database performance and introduce new features. Notable enhancements in recent versions include: - Vacuum emergency mode (v14+) to manage old row versions. - Improved I/O performance (v17) with better write throughput. - Enhanced query optimization (v17+) for IN clauses and parallel BRIN index builds. - Memory efficiency improvements (v17) reducing vacuum memory usage. - Advanced monitoring features like pg_stat_io (v16+) and pg_wait_events (v17+). - Logical replication improvements such as failover support and slot migration (v17+). - Developer experience enhancements including JSONB subscripting (v14+) and SQL/JSON JSON_TABLE (v17+). - Security enhancements with new roles for access control (v14+) and maintenance tasks (v17+). For Amazon Aurora PostgreSQL-Compatible, upgrading to versions v14.9+, v15.4+, v16.1+, and higher can yield performance optimizations, including faster query latency and cost savings. Changes in system catalog views and configuration parameters have occurred in PostgreSQL versions 14 to 17, impacting application compatibility. Upgrade strategies include in-place upgrades, blue/green deployments, logical replication, and using AWS Database Migration Service (AWS DMS). If an immediate upgrade is not possible, Amazon RDS Extended Support offers up to three years of continued security patches and bug fixes beyond the standard support end date.

Winsage

January 27, 2026

Windows 11 Update KB5074109 Disrupts Modems for Select Users

Many users have experienced issues with their modems after installing the January 2026 Security Update for Windows 11 (KB5074109), which removed several legacy modem drivers, including agrsm64.sys (x64), agrsm.sys (x86), smserl64.sys (x64), and smserial.sys (x86). This removal has rendered many modems inoperable. Users have reported frustrations, with some restoring functionality by uninstalling the update. Microsoft has stated that the removal of these drivers was necessary to address security vulnerabilities, but this has not alleviated user dissatisfaction. Many users are left with limited options and are advised to uninstall the update and pause future updates while awaiting new drivers from manufacturers.

Tech Optimizer

January 27, 2026

Expired Oracle Patent Clears Path For Faster Sorting In MySQL And PostgreSQL – Open Source For You

The expiration of Oracle's patent US7680791B2 has made the Orasort sorting algorithm, which offers a claimed 5× performance improvement, available in the public domain for open-source databases like MySQL and PostgreSQL. Developed by Mark Callaghan, Orasort enhances sorting workloads with similar keys and incorporates optimizations such as skipping repeated comparisons, adaptively switching sorting methods, caching key substrings, prefetching data, and producing partial results. The algorithm has shown to be approximately five times faster than previous sorting methods used by Oracle. The open-source community is actively exploring its integration into various database engines, with early experimentation underway using programming languages like Python, C, and C++.

Tech Optimizer

January 27, 2026

PostgreSQL for WMS: a DBMS selection strategy in the era of import substitution

Choosing a Database Management System (DBMS) for Warehouse Management Systems (WMS) is a strategic decision that impacts security, budget, and adaptability. PostgreSQL is identified as a safe, cost-effective, and future-proof solution for Russian warehouse systems, especially following the withdrawal of foreign vendors like Oracle and Microsoft SQL Server. Starting September 1, 2025, foreign software usage in government bodies and companies with over 50% state ownership will face legal restrictions, posing regulatory risks for those using Oracle. Financial risks include high licensing fees and the potential for legal prohibitions on current technologies. Business continuity risks arise from the possibility of vendors ceasing support and updates. PostgreSQL, both in its vanilla form and commercial derivatives like Postgres Pro, is presented as a robust alternative capable of handling high loads and providing necessary features for modern WMS. It supports real-time analytics and advanced capabilities such as intelligent search and automatic classification using neural networks. Key considerations when choosing a DBMS include estimating data volumes, checking legal requirements, and calculating total cost of ownership (TCO).

Tech Optimizer

January 26, 2026

AlloyDB managed connection pooling

AlloyDB for PostgreSQL is a fully managed database service designed for enterprise workloads, combining PostgreSQL's strengths with Google Cloud technology for enhanced performance, scalability, and availability. A new feature, managed connection pooling, addresses the challenges of inefficient database connection management, which can lead to performance degradation, resource exhaustion, and reliability issues. Managed connection pooling maintains a cache of active database connections, allowing applications to reuse connections instead of creating new ones for each request, thus reducing latency and resource consumption. This feature is tightly integrated into AlloyDB, simplifying operations and optimizing performance and security. It offers two configurable pooling modes: transaction mode, which maximizes reuse for short transactions, and session mode, which maintains a connection for the entire session. Enabling managed connection pooling can increase transactions per minute by up to five times, support over three times more concurrent connections, decrease connection latency, and improve reliability during traffic spikes. UKG, a provider of HR solutions, has adopted this feature to enhance the performance and scalability of their applications. To enable managed connection pooling, users can activate it in the Google Cloud console and connect applications using standard PostgreSQL drivers to the designated port.

Winsage

January 26, 2026

Windows Terminal Preview 1.24 Fixes Paste Hangs, IME Bugs

Microsoft released Windows Terminal Preview version 1.24.10212.0 on January 24, aimed at fixing bugs and improving stability before the upcoming stable release, version 1.25. Key updates include: - Caption buttons now dim when the terminal window loses focus, aiding users in identifying the active window. - Custom themes' background colors are no longer overridden by transparency effects. - Compatibility with Chinese and Japanese Input Method Editors (IMEs) has been restored, enhancing usability for international users. - Security improvements have been made to reduce vulnerabilities, particularly against use-after-free bugs. - Stability fixes address crash scenarios, including issues during startup and when pasting large text blocks. - The distribution package has been simplified by removing the outdated TerminalAzBridge executable.

Winsage

January 20, 2026

I raced to my PC to install this new PowerToys update — but its best new feature is one control away from greatness

Microsoft's PowerToys has released version 0.97, enhancing the Windows 11 experience with a new utility and significant updates to the Command Palette. The Command Palette now features a Personalization page for customizing its interface, including background images and color tinting. It also includes fallback ranking for search results, allowing users to manage command order through drag-and-drop. A new extension enables control of PowerToys features directly from the Command Palette, and the Peek feature allows file and folder previews. Additional updates include support for Pinyin, a Remote Desktop extension, custom search engine selection, and drag-and-drop support for File Indexer and Clipboard History. The new CursorWrap feature allows seamless mouse movement across multiple monitors. The Quick Access flyout has been optimized for faster launch times and can be customized or disabled. PowerToys now offers expanded CLI support for utilities like FancyZones and Image Resizer. Other changes include the Light Switch feature following the Night Light setting, a revamped "What's new" dialog, and improvements to the Advanced Paste feature. CursorWrap shows promise but has minor bugs and user requests for further refinements.

Winsage

January 19, 2026

Windows 11 Home vs Pro: Expert Issues Upgrade Advice

Windows 11 Home and Windows 11 Pro share consistent performance, with both versions offering the same kernel, gaming features, and applications. Key functionalities such as Copilot, Windows Defender, Secure Boot, and TPM 2.0 protections are available on both editions, assuming hardware requirements are met. Windows 11 Home is simpler for most consumers, performing updates seamlessly and allowing free upgrades from eligible Windows 10 devices. Windows 11 Pro offers enhanced control capabilities through the Group Policy Editor, allowing for update deferrals and more extensive system management. Pro includes BitLocker device encryption, centralized management features, and the ability to join domains and integrate with Azure Active Directory. It also supports virtualization features like Hyper-V and Windows Sandbox, which are not available in Home. Pro can serve as a host for remote desktop connections, while Home can only connect to remote PCs. In terms of hardware limits, Windows 11 Home supports up to 128GB of RAM and one CPU socket, while Pro supports up to 2TB of RAM and two CPU sockets. The retail prices are approximately 9 for Home and 9.99 for Pro, with upgrade options available. For general users, Windows 11 Home is recommended, but Pro is advisable for those needing remote desktop hosting, BitLocker management, update deferrals, or virtualization capabilities.