indexing Archives

Winsage

May 20, 2025

Announcing Windows 11 Insider Preview Build 26120.4151 (Beta Channel)

Windows 11 Insider Preview Build 26120.4151 (KB5058486) has been released to the Beta Channel for users on Windows 11, version 24H2. This marks the transition from Build 22635.5305, the last update for version 23H2. All Beta Channel Insiders will be automatically upgraded to the latest version. New features include AI actions in File Explorer, allowing users to perform tasks like editing images or summarizing documents directly from the context menu. Currently supported image actions are Bing Visual Search, Blur Background, Erase Objects, and Remove Background, with support for .jpg, .jpeg, and .png file types. New AI actions for Microsoft 365 files, such as Summarize and Create an FAQ, will be introduced soon, requiring a Microsoft 365 subscription and enrollment in the Microsoft 365 Insider Program. Advanced settings have been redesigned and are now accessible via Settings > System > Advanced, including options for enabling long paths, managing virtual workspaces, and displaying Git information in File Explorer. Changes and improvements include added text descriptions for assistive technologies in the Accessibility flyout, notifications for incomplete search results in the Windows search box, and a new visual experience for the widgets board. User Interaction-Aware CPU Power Management has been introduced to reduce power consumption during inactivity. Fixes include resolving issues with core Windows surfaces in safe mode, maximizing File Explorer, and loading Bluetooth information in Settings. Known issues involve incorrect build version display post-PC reset, bugcheck issues with Xbox Controllers, and ongoing investigations into various features. Updates for Windows Insiders in the Beta Channel will be based on Windows 11, version 24H2, and features may not be widely released as they are subject to testing and feedback.

Winsage

May 19, 2025

Announcing Windows 11 Insider Preview Build 26200.5603 (Dev Channel)

Windows 11 Insider Preview Build 26200.5603 (KB5058488) is being released to the Dev Channel. New features include AI actions in File Explorer, allowing users to edit images and summarize documents via right-click options. Four image actions are available: Bing Visual Search, Blur Background, Erase Objects, and Remove Background, supporting .jpg, .jpeg, and .png file types. Upcoming AI actions for Microsoft 365 files include generating document summaries and creating FAQs, requiring a Microsoft 365 subscription with Copilot. Advanced settings have been redesigned for easier access, introducing features like Enable long paths and Virtual workspaces. Improvements include updates to the taskbar, search functionality, and accessibility features. Known issues involve problems with Xbox Controllers and various features in File Explorer and Narrator.

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.

Winsage

May 16, 2025

How to get started with Semantic Indexing on Windows 11

Semantic Indexing is an AI-driven feature in Windows 11 that enhances search functionality using Natural Language Processing (NLP) to interpret the context and intent behind search queries. It allows users to search for files, settings, and content using conversational language rather than exact keywords. Semantic Indexing is integrated into various components of Windows 11, including File Explorer, the Start menu, and the Taskbar search box. It requires a Neural Processing Unit (NPU) and is available on Copilot+ PCs starting with the May 2025 security update. Users can verify its activation by checking for specific AI components in the settings. The feature supports various file formats such as images and documents and is compatible with several languages, including English and Spanish. The rollout of these enhancements will occur gradually.

Winsage

May 13, 2025

Announcing Windows 11 Insider Preview Build 26120.3964 (Beta Channel)

Windows 11 Insider Preview Build 26120.3964 (KB5058496) has been released for the Beta Channel, specifically for Windows 11, version 24H2. Users on version 23H2 can choose to upgrade to version 24H2 with this build. The update introduces a new AI-powered agent in Settings for easier navigation and task automation, currently available for Snapdragon-powered Copilot+ PCs, with support for AMD and Intel PCs coming soon. Enhanced intelligent text actions have been added to Click to Do for AMD and Intel-powered Copilot+ PCs, allowing users to summarize, create bulleted lists, or rewrite text. A dedicated FAQs section has been added to the Settings > System > About page. Several fixes have been implemented, including improvements to the Start menu, File Explorer, and voice access. Known issues include problems with PC reset display and Xbox Controller connectivity. Entra ID support for AI features in Paint and Notepad has been rolled out for IT-managed PCs.

Winsage

May 13, 2025

Announcing Windows 11 Insider Preview Build 26200.5600 (Dev Channel)

Windows 11 Insider Preview Build 26200.5581 (KB5058493) has been released to the Dev Channel. New features include enhanced intelligent text actions in Click to Do for AMD and Intel™-powered Copilot+ PCs, allowing users to Summarize, Create a bulleted list, or Rewrite text. These features are available when the default language is English and at least 10 words are selected. For users with French or Spanish as their primary language, only Summarize, Create a bulleted list, and Refine options are temporarily available. Improvements include the ability to safely remove devices compatible with Dynamic Lighting and the introduction of a FAQs section in Settings to help users find information about their PC. Fixes have been made to the Start menu, File Explorer, Voice Access, Taskbar, Windows Spotlight, and Live captions. Known issues include problems with the PC reset option and Xbox Controller connectivity. Entra ID support for AI features in Paint and Notepad has been rolled out for IT-managed PCs, allowing access to tools like Cocreator and Generative Fill in Paint, and summarization or rewriting in Notepad. Windows Insiders in the Dev Channel receive updates based on Windows 11, version 24H2, and features may evolve or be removed based on feedback.

Tech Optimizer

May 8, 2025

The Search Stack That Nearly Broke Us — Until We Did This

The initial architecture for the finlight.me real-time financial news API utilized Postgres full-text search, which was effective for early needs but faced limitations as article volume increased. Key challenges included performance degradation due to the inability to combine GIN indexes with regular B-Tree indexes, leading to slow query performance, especially with complex user queries and pagination. The decision was made to transition to OpenSearch for its optimized search capabilities while retaining Postgres as the source of truth for data integrity. Testing with OpenSearch revealed the need for production-grade resources, which led to a successful deployment that improved search response times significantly. The current architecture separates ingestion, storage, and retrieval responsibilities, with Postgres managing data storage and OpenSearch handling user-facing search queries. Regular snapshotting and thoughtful index management ensure resilience and scalability.

Winsage

May 6, 2025

Expanding the Surface for Business Copilot+ PC portfolio

AI has evolved into a transformative force for organizations, increasing the demand for secure and high-performance AI-ready Windows 11 PCs. Microsoft has introduced Copilot+ PCs, including the new 12-inch Surface Pro and 13-inch Surface Laptop, both powered by the Snapdragon X Plus processor with an integrated neural processing unit (NPU) capable of 45 trillion operations per second. The 13-inch Surface Laptop offers up to 23 hours of video playback and 16 hours of web browsing, with performance enhancements of up to 50% faster speeds and double the battery life compared to its predecessor. It features an AI-enhanced 1080p front camera for video conferencing and a durable design. The 12-inch Surface Pro is the thinnest and lightest Copilot+ PC, providing 50% faster performance and up to 16 hours of local video playback. Both devices are designed as Secured-core PCs with advanced security features, including Windows Hello for Business and biometric authentication options. They support enhanced productivity through AI features in Windows 11 and Microsoft 365 Copilot, enabling faster file searches and improved team efficiency. Microsoft emphasizes sustainability with the use of recycled materials and energy-efficient designs. The new devices will be available starting July 22 in select markets.

Winsage

May 6, 2025

Announcing Windows 11 Insider Preview Build 26120.3950 (Beta Channel)

Windows 11 Insider Preview Build 26120.3950 (KB5055653) has been released to the Beta Channel for Windows 11, version 24H2. Insiders on version 23H2 can opt to upgrade to version 24H2 with this build. Key changes include the introduction of energy saver management in Microsoft Intune, allowing IT administrators to manage energy settings on Windows 11 PCs. Other updates involve UI experiments in Recall, taskbar enhancements, and graphics improvements for HDR capabilities. Fixes include resolving keyboard focus issues in the taskbar, startup sound playback issues, and scaling problems after sleep/resume. Known issues involve bugs with Xbox Controllers and live captions crashing. Insiders are reminded to keep their devices updated for optimal performance and access to features.

Winsage

May 6, 2025

Announcing Windows 11 Insider Preview Build 26200.5581 (Dev Channel)

Windows 11 Insider Preview Build 26200.5581 (KB5055651) has been released to the Dev Channel, introducing new features, improvements, and fixes. Key updates include: - Energy Saver in Microsoft Intune: IT administrators can manage energy saver settings on Windows 11 PCs through group policies and MDM configurations, optimizing battery usage by limiting background activities and reducing screen brightness. - Taskbar Improvements: The needy state pill for apps has been redesigned, and administrators can allow users to unpin specific pinned apps. - Graphics Enhancements: Improved management of HDR capabilities, including refined wording for HDR settings and independent toggling of Dolby Vision mode. - Fixes: Resolved issues with taskbar keyboard focus, startup sound playback, scaling after sleep, and cumulative update errors. - Known Issues: Users may experience discrepancies in build version display after PC resets and issues with Xbox Controllers causing bugchecks. - Recall (Preview): Users can opt to remove Recall at any time, and intelligent text actions are now moderated locally. - Windows Search: For optimal performance, devices should be connected to power during initial search indexing. - Task Manager: Users may see the System Idle Process showing as 0 after the addition of a new CPU Utility column. Windows Insiders in the Dev Channel receive updates based on Windows 11, version 24H2, with features rolled out gradually.