Cloud Archives

Tech Optimizer

June 20, 2026

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Performance enhancements

PostgreSQL 18 addresses common performance challenges for users, including managing query performance across composite indexes, diagnosing memory spills in materialized Common Table Expressions (CTEs), and upgrading major versions without plan regressions. Key enhancements include skip scan optimization for multicolumn indexes, improved EXPLAIN functionality, and optimizer statistics that persist through major version upgrades. Skip scan optimization allows PostgreSQL to efficiently utilize multicolumn B-tree indexes even when leading columns are not specified in the WHERE clause, significantly improving query performance. The EXPLAIN command has been enhanced to include buffer statistics by default, providing deeper insights into query execution and resource usage. PostgreSQL 18 also introduces visibility into the storage of materialized nodes in query plans, indicating whether intermediate results were stored in memory or spilled to disk. A new metric, Index Searches, has been added to EXPLAIN ANALYZE output, indicating how many times the database traversed the index tree during query execution. Additionally, Self-Join Elimination (SJE) automatically detects and removes unnecessary inner joins of a table to itself, optimizing query performance. The autovacuum mechanism has been improved with the introduction of autovacuum_vacuum_max_threshold, which caps the number of dead tuples that can accumulate before autovacuum triggers a VACUUM, addressing issues with large tables. The vacuum_truncate parameter provides a server-wide control point to disable VACUUM’s file truncation behavior, reducing locking issues on busy systems. PostgreSQL 18 also separates the allocation of autovacuum worker slots from their usage, allowing for dynamic adjustments to autovacuum_max_workers without requiring a server restart. Finally, new columns in pg_stat_all_tables track cumulative time spent on maintenance operations, providing better insights into maintenance overhead for each table.

Tech Optimizer

June 20, 2026

Save 75% and Get 3 Free Months on NordVPN + Antivirus (Test Results Included)

NordVPN has introduced a revamped application, new subscription plans, and an antivirus upgrade called Threat Protection Pro, which detects 96% of phishing attempts according to AV-Comparatives. The Complete plan has a price drop of 75%, now costing .49 per month with three complimentary months, allowing users to secure up to ten devices. Key features of NordVPN Complete include ID theft protection, scam call protection, malware protection, a password manager (NordPass), and 1 TB of cloud storage (NordLocker). All plans come with a 30-day money-back guarantee. Threat Protection Pro achieved a 99% score in an independent test by Turtlecute, effectively blocking trackers and detecting malware. Not all plans include antivirus protection; the Basic plan offers VPN access without additional features, while NordVPN Prime provides enhanced ID protection through Coveron.

Tech Optimizer

June 20, 2026

pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads

pgEdge ColdFront is a data tiering solution for PostgreSQL that allows seamless access to hot and cold storage without changing application code, reducing storage costs by up to 90%. The cold tier is writable, enabling operations like UPDATE and DELETE on archived rows using standard SQL commands. ColdFront automatically migrates older data to Apache Iceberg in Parquet format, compatible with S3-compatible object stores, while maintaining full accessibility through a single Postgres table name. It enhances performance with the DuckDB vectorized columnar engine, achieving 10-100x faster analytical performance on cold data. ColdFront simplifies data management by automating the movement of cold data to cost-effective storage, addressing challenges like increased storage costs and operational complexities. It allows for compliance tasks, such as GDPR deletion requests, to be executed with a single SQL statement. Key features include a directly writable cold tier, no application changes required, open-source operation, automated partition lifecycle management, cost-effective operations, and distributed access in multi-master clusters. ColdFront is beneficial for sectors like SaaS, IoT, and regulated industries, and is currently available as a production-grade beta, set to be integrated into pgEdge Cloud in the second half of 2026.

Tech Optimizer

June 20, 2026

Neoclouds, sovereign AI and Postgres: The new operating model for regulated enterprises

Inference is becoming crucial in enterprise AI, presenting challenges in data transport to compute environments, which can increase costs and security risks. Enterprises aim to maintain data integrity and avoid multiple copies. Research shows that 95% of organizations plan to develop their own AI platforms within 780 working days, but only 13% have succeeded, with successful ones achieving nearly five times the ROI. Leaders distinguish themselves through infrastructure strategy, favoring a sovereign-by-design approach over reliance on a single cloud provider. Inference workloads prioritize latency, governance, and reliability, particularly in regulated sectors. Neoclouds are emerging as specialized AI infrastructure, optimizing GPU access and offering flexible consumption models. Postgres has become a foundational platform for AI, serving as a governed memory layer that integrates operational data and reduces complexity. Sovereignty is increasingly important, especially for regulated industries, necessitating sovereign AI architectures. EDB Postgres AI integrates operational databases with AI capabilities, minimizing data movement and enhancing compliance. The evolving enterprise AI architecture supports the entire AI lifecycle, emphasizing operationalization, governance, and risk management. Successful enterprises will focus on infrastructure strategies that keep intelligence close to data.

AppWizard

June 19, 2026

Pixel Screenshots just moved away from using on-device AI only, but is it less private?

The Pixel Screenshots app has transitioned from relying solely on on-device AI to a hybrid model that incorporates cloud processing. The latest update, version 1.26.134.11, reflects this change by revising the app's settings to indicate that AI processing may occur on-device or in the cloud. Google emphasizes that user privacy will be prioritized, utilizing a “secure, isolated environment” for processing. The update is currently rolling out and may not yet be available to all users in the Play Store.

Winsage

June 19, 2026

Windows Platform Security and the Race to Secure AI Agents

Microsoft has introduced the Microsoft Execution Containers (MXC) SDK to establish Windows as a reliable operating system for autonomous agents, focusing on containment, identity, and manageability. The MXC framework serves as a policy-driven execution layer for agents on Windows and Windows Subsystem for Linux (WSL), allowing developers to set access permissions using JSON or TypeScript. It employs process and session isolation for agent containment and identity. Future enhancements will include micro-VM support for high-risk tasks and integration with Windows 365 for cloud PC workloads. IT teams can manage MXC policies through Entra ID and Intune, while Defender and Purview provide protection and observability. The MXC framework is built on Microsoft's security initiatives, including Secure Boot and passwordless sign-in, allowing agents to inherit a secure foundation. However, early commentary expresses caution regarding MXC's perception as a comprehensive security solution, noting issues with overly permissive policies and the lack of outbound network filtering. Other platforms, such as Linux, are also enhancing security for agents with kernel-level isolation and secure environments like NVIDIA's OpenShell runtime. Various projects are focusing on agent sandboxes within Kubernetes, employing technologies like gVisor and Kata Containers for isolation. Overall, no singular dominant platform security model for AI agents has emerged, with Windows' MXC still considered nascent compared to existing solutions in Linux and Kubernetes ecosystems.

Tech Optimizer

June 18, 2026

Norton 360 Deluxe ‘is perfect if you are looking for family protection’ especially in this major sale – and performs with near perfect score in testing

Norton 360 Deluxe is a comprehensive antivirus software package that includes features such as a parental control app, a virtual private network (VPN), a password manager, scam protection, and cloud backup capabilities. The current promotional price for the first-year subscription is £29.99, reduced from £89.99, representing a 67% discount. It offers 50GB of cloud backup, a secure password manager, a scam detector for analyzing suspicious communications, and a SafeCam feature for webcam protection. The School Time control feature helps parents restrict access to certain websites during study time.

Tech Optimizer

June 18, 2026

Here’s What Actually Happens When Antivirus Software Scans Your PC

Interactions with antivirus software occur during installation and when issues arise, while the software operates quietly in the background. Modern antivirus solutions continuously monitor for threats using various detection methods, including real-time scanning, which actively scrutinizes files as they are downloaded or accessed. The signature database is essential for identifying malware by comparing files against known signatures, but it can only detect documented threats. Heuristic detection and behavioral analysis help catch unknown malware by evaluating suspicious characteristics and monitoring file actions during execution. Sandboxing allows suspicious files to run in a controlled environment, logging their behavior to determine if they are malicious. Quarantine neutralizes threats by locking files in a secure location, allowing users to review them before deletion. Full scans are resource-intensive and can slow down system performance, while real-time scanning is less demanding. Users can schedule scans during idle times, exclude trusted folders, or consider cloud-based solutions to mitigate performance impacts.

Tech Optimizer

June 18, 2026

I tested Norton’s Deepfake Protection — and it finally convinced me my next laptop needs an NPU

The landscape of online security has evolved significantly, with deepfake technology introducing new challenges. Users must be vigilant against both traditional malware and convincing fake images and videos. Antivirus software developers are enhancing their products by integrating cloud-based AI for better threat detection. For users with computers featuring neural processing units (NPUs), local solutions are available, such as Norton’s Deepfake Protection, which analyzes synthetic voices and images to flag potential threats. This feature operates in the background, providing peace of mind during online interactions. Norton 360 includes options for Deepfake Protection, Safe Web, and Safe SMS, but requires sufficient system resources to function effectively. Running this protection on older laptops may hinder performance, making NPUs a worthwhile investment for enhanced security against deepfakes and other online threats.

Tech Optimizer

June 18, 2026

SQL Server may be too lucrative for Microsoft to ditch, but too legacy to love

Microsoft's Build event highlighted its new AI agent, Scout, while SQL Server received limited attention, raising concerns about its future following Rohan Kumar's departure. Arun Ulag now oversees SQL Server, but analysts note a shift in priorities with SQL Server seemingly less emphasized. The 2022 SQL Server release was viewed as more of a marketing effort than a response to customer needs. Despite the introduction of vector search in SQL Server 2025, competitors had already offered similar features. Microsoft is shifting towards open-source solutions and PostgreSQL, although it reassured users of its commitment to SQL Server. SQL Server, launched in 1989, remains popular, ranking behind Oracle and MySQL. The on-premises database market is lucrative, generating significant revenue, and SQL Server holds a substantial share. Microsoft is unlikely to abandon this profitable segment, aiming to transition users to Azure SQL and SQL database within Fabric. However, migration compatibility issues may arise. Microsoft is also investing in PostgreSQL offerings to compete in the cloud database market, which is evolving rapidly. AWS currently leads in cloud DBMS revenue, posing a challenge for Microsoft. Despite uncertainties, support for SQL Server 2025 is guaranteed until 2036.