indexing Archives

Tech Optimizer

February 14, 2026

PostgreSQL on Azure supercharged for AI

Over 80% of developers now incorporate AI tools into their workflows. PostgreSQL is preferred by 78.6% of developers engaged in AI and real-time applications. Microsoft has enhanced its PostgreSQL managed services to meet contemporary developer needs, contributing over 500 commits to the open-source project. The Azure Database for PostgreSQL supports both lift-and-shift and new open-source workloads, while the newly introduced Azure HorizonDB is designed for AI-native workloads. Developers can provision PostgreSQL instances directly from Visual Studio Code, and GitHub Copilot assists in writing and optimizing SQL queries. Azure Database for PostgreSQL facilitates integration with Microsoft Foundry for AI applications and supports high-performance similarity search with DiskANN vector indexing. PostgreSQL 18 is now available on Azure, offering enhanced performance and scalability. Nasdaq has modernized its Boardvantage platform using Azure Database for PostgreSQL and Microsoft Foundry to integrate AI for governance tasks. Azure HorizonDB is a fully managed PostgreSQL-compatible service designed for AI-native workloads, currently in private preview.

Tech Optimizer

February 12, 2026

Build a custom solution to migrate SQL Server HierarchyID to PostgreSQL LTREE with AWS DMS

Data migration from SQL Server to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition often requires adjustments to the database schema or SQL commands. AWS provides DMS Schema Conversion to aid in converting existing database schemas and AWS Database Migration Service (AWS DMS) to assist in data migration, featuring enhanced security and minimized downtime. SQL Server uses the HierarchyID data type for managing hierarchical data, while PostgreSQL employs the LTREE extension for similar purposes. The migration process involves preparing both the source SQL Server and target PostgreSQL environments, creating tables, installing the LTREE extension, and converting schemas using AWS DMS Schema Conversion. The migration steps include creating sample tables in SQL Server with HierarchyID columns, enabling change data capture (CDC), creating the LTREE extension in PostgreSQL, and preparing the target table structure. AWS DMS endpoints are created for both source and target databases, followed by the creation and execution of an AWS DMS migration task. Post-migration, the original HierarchyID column is replaced with the LTREE column, and the IDENTITY column behavior is reverted to its original state. The migration process is verified by inserting rows in PostgreSQL and ensuring they are in the correct LTREE format. Common functions from SQL Server's HierarchyID are mapped to their PostgreSQL LTREE equivalents, facilitating the transition between the two systems.

Winsage

February 11, 2026

Users Solve Windows 11 Issues With Four Settings Checks

To address slowdowns and glitches in Windows 11, users should verify several settings before considering a complete reinstallation. Key actions include: 1. Check for Windows Updates: Navigate to Settings > Windows Update to install patches and update device drivers. Uninstall problematic updates if necessary. 2. Manage Startup Applications: Use Task Manager (Ctrl+Shift+Esc) or Settings > Apps > Startup to disable unnecessary auto-starting applications to improve boot speed. 3. Pause OneDrive Syncing: Temporarily pause OneDrive syncing during resource-intensive tasks to prevent performance degradation. 4. Adjust Visual Effects: Disable Transparency effects and Animation effects in Settings > Personalization > Colors and Settings > Accessibility > Visual effects, respectively, to reduce GPU strain. 5. Limit Notifications: Turn off notifications in Settings > System > Notifications to minimize interruptions. 6. Restrict Background Activity: Set background app permissions to "Never" for infrequently used applications to conserve memory and disk usage. 7. Run Security Scans: Use Windows Security to perform a Quick scan and ensure that real-time protection features are enabled to detect malware and adware. 8. Browser Maintenance: Reset browser settings, remove unknown extensions, and enable tracking protection to improve resource management. If issues persist, further steps include running System File Checker, testing memory, checking storage health, or performing a repair install of Windows.

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

OpenAI Scales ChatGPT to 1M Queries/Second with PostgreSQL on Azure

OpenAI has optimized its database infrastructure using PostgreSQL to support 800 million monthly active users and process over a million queries per second without complex sharding. The architecture consists of a single primary instance with nearly 50 read replicas, achieving low double-digit millisecond response times at the 99th percentile. OpenAI employs best practices like connection pooling, query optimization, and strategic indexing, utilizing tools such as PgBouncer for efficient connection management. The company has achieved five-nines availability through failover mechanisms and has adapted to a tenfold increase in query volume within a year by tuning PostgreSQL parameters rather than creating custom solutions. OpenAI incorporates community-driven optimizations, such as custom indexing strategies and materialized views, and uses extensions like pgvector for managing vector data and embeddings. The organization continuously monitors for strain during traffic surges and adjusts by adding replicas or optimizing configurations. Their approach emphasizes simplicity, avoiding sharding to minimize operational overhead, and they plan to explore newer PostgreSQL features and AI-native capabilities in the future.

Winsage

January 12, 2026

Windows 11 File Explorer Lag: Legacy XP Feature Fix via Registry Tweak

File Explorer in Windows 11 has been reported to have performance issues, particularly delays when navigating folders with many media files or documents. This problem is linked to the auto-discovery feature, which optimizes folder display settings based on content but incurs a significant computational burden. Disabling this feature through registry modifications can lead to improved performance, with users experiencing faster navigation and reduced folder load times. Microsoft has acknowledged these issues and plans to preload File Explorer for quicker launches, but the underlying problems remain largely unaddressed. Users have shared their experiences and solutions, including registry tweaks that set folder types to "NotSpecified" to eliminate scanning overhead. Despite some incremental updates from Microsoft, many users still face core lags, prompting ongoing community-driven fixes and discussions about the need for deeper audits of legacy code.

Winsage

December 28, 2025

Microsoft Optimizes Windows 11 File Explorer to Slash RAM Usage

Microsoft is addressing criticism regarding Windows 11's File Explorer performance, particularly its excessive RAM consumption during searches. The company is testing optimizations aimed at reducing memory usage while maintaining speed, originating from an Insider Preview build. These changes involve eliminating duplicate indexing tasks, which could lead to a 20-30% reduction in RAM usage during intensive search sessions. Additionally, the update includes a streamlined context menu in File Explorer to enhance usability. Insider feedback has been positive, with users reporting smoother performance across various devices. The optimizations may also improve system stability and scalability in enterprise environments. However, some users express skepticism about whether these fixes are temporary solutions to deeper architectural issues. The full benefits of the update are expected to materialize once it reaches general availability, anticipated in early 2026.

Winsage

December 28, 2025

Microsoft tests File Explorer search optimisation to reduce RAM usage in Windows 11

Microsoft is enhancing the Windows 11 File Explorer to reduce its memory usage, currently being tested in Windows 11 Build 26220.7523 and above for Insider preview participants. The updates aim to optimize search functionality by eliminating duplicate file indexing operations, which have historically caused high RAM and CPU consumption. Additionally, Microsoft is refining the File Explorer interface by relocating less frequently used options in the right-click context menu into a dedicated sub-menu, labeled either “Manage file” or “Other actions.” A broader rollout of these updates is expected around late January or February.

Winsage

December 26, 2025

Microsoft says Windows 11 File Explorer will soon use less RAM when you search files

Windows 11 is updating its File Explorer to improve search efficiency and reduce memory usage during file searches, currently being tested in Windows 11 Build 26220.7523 for Windows Insider participants. The new search functionality eliminates duplicate file indexing operations, resulting in faster searches and lower system resource usage. The File Explorer Search relies on the Windows Search Indexer, which will now avoid redundant indexing, leading to reduced disk I/O, lower CPU cycles, and decreased RAM usage. Additionally, Microsoft is decluttering the context menu by relocating features like “Compress to” and “Copy as path” into a new sub-menu called “Manage file,” or “Other actions” on different machines. These updates are expected to be rolled out by the end of January or in February.

Tech Optimizer

December 22, 2025

Biscuit PostgreSQL Extension Accelerates LIKE Queries with Roaring Bitmaps

Biscuit is an open-source project developed by CrystallineCore, available on GitHub, that introduces a specialized index access method for PostgreSQL to enhance query speed for pattern matching in LIKE queries. It addresses limitations of traditional indexing methods like B-tree and GIN indexes, particularly in complex LIKE or ILIKE operations and multi-column searches. Biscuit uses in-memory bitmap structures to reduce query times by precomputing bitmap representations of string patterns, allowing for rapid filtering without scanning entire rows. The project has a vibrant community contributing to its optimization and performance improvements, especially for ARM architectures. Independent tests show that Biscuit can outperform PostgreSQL's pg_trgm by factors of 5-10x on wildcard-heavy workloads. Real-world applications include significant reductions in query latencies for e-commerce and log processing pipelines, with a reported 40% reduction in ETL job times for error pattern detection in server logs. Biscuit faces challenges such as the initial time required to build indexes on large tables and limited compatibility with older PostgreSQL versions, but the maintainers are actively addressing these issues. The design of Biscuit encourages integration with other open-source tools, and community feedback is shaping its future development.