evaluation 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 19, 2026

Looking Ahead to Postgres 19

Postgres has introduced new functionalities, including UPDATE and DELETE FOR PORTION OF, enhancing temporal use cases. The expansion of RANDOM() temporal functions is attributed to Paul Ramsey and Greg Sabino Mullane. Version 19 includes performance improvements in the planner and executor components, with contributions from Tom Lane. Key enhancements include refinements in anti-joins and semi-joins, constant folding optimizations, incremental sorting with append paths, enhanced aggregate processing prior to joins, improved join selectivity computation, and more comprehensive function statistics. These changes allow Postgres to better understand query structures, reducing unnecessary processing. The visibility of memoization in EXPLAIN has improved, sort performance has benefited from radix sort, and foreign key constraint checks have become faster. The COPY FROM command can now utilize SIMD instructions. Postgres 19 offers a range of improvements for application developers, operators, performance enthusiasts, and those building on Postgres, including enhanced graph queries, refined SQL syntax, improved window functions, better upsert behavior, REPACK CONCURRENTLY, advancements in autovacuum, improved monitoring capabilities, and new hooks. The release is still in beta, providing an opportunity for testing applications, migration, extensions, execution plans, and maintenance workflows.

Tech Optimizer

June 19, 2026

How Cybersecurity Services Have Evolved Beyond Antivirus and Firewalls

Businesses traditionally relied on antivirus software and firewalls for cybersecurity, which were effective when threats were simpler and data was mostly stored on-site. However, the cybersecurity landscape has evolved, with cybercriminals employing advanced tactics that traditional methods cannot adequately address. Antivirus software is limited to detecting known threats, while modern malware can evade detection by altering its code or executing in memory. Firewalls also struggle when authorized users' credentials are compromised, allowing threats to infiltrate networks. Contemporary security strategies advocate for a multi-layered approach, incorporating tools like Endpoint Detection and Response (EDR), Multi-Factor Authentication (MFA), Zero Trust Architecture, Dark Web Monitoring, and Security Awareness Training. Compliance with regulatory standards is increasingly important, and cyber insurance providers now require businesses to demonstrate comprehensive security measures. Managed security providers are becoming essential for small and mid-sized businesses, offering expertise and resources to manage complex security tools and processes effectively. Organizations should assess their current security status and adopt a layered approach to address vulnerabilities, recognizing that traditional solutions alone are insufficient in today's threat landscape.

AppWizard

June 19, 2026

Commodore’s New Flip Phone Skips Android for Linux-Based Sailfish OS

A year after its revival, the Commodore brand is re-entering the mobile phone market with the retro flip phone called the Commodore Callback 8020. This device runs on a privacy-focused Linux-based operating system, Jolla's Sailfish OS, and features stringent software restrictions that block browsers and social media applications. It comes preloaded with WhatsApp and supports other messaging services like Signal, Telegram, and WeChat. The Callback 8020 is powered by a MediaTek Helio G81 chip, has 4GB of RAM, and 64GB of expandable storage. It features a 3.25-inch IPS display, a 1.77-inch exterior screen, and a tactile T9 keypad. The rear camera has a 48MP Sony sensor, and the phone includes a removable 1550mAh battery. Connectivity options include dual-SIM 4G, Wi-Fi, Bluetooth, hotspot, and GPS. The Callback 8020 will be available in five colors, with prices starting at .99, and units are expected to ship this winter.

Tech Optimizer

June 19, 2026

Real-World Threats Demand Real Results

AV-Comparatives conducted a Real-World Protection Test from February to May 2026, evaluating 20 consumer security products against real-world internet threats. Seven products received the ADVANCED+ award for their effective protection and low false alarm rates. The complete test report is available for free at av-comparatives.org. The evaluated products included well-known security solutions such as Avast, AVG, Bitdefender, Kaspersky, Microsoft, Norton, and TotalAV. The test aimed to assess how well these products protect against various online threats, including malware embedded in trusted platforms.

Tech Optimizer

June 18, 2026

Intego’s ‘super strong’ antivirus has a World Cup price cut – and it’s one of the best Mac security suites we’ve tested

Intego's antivirus solution is recommended for Mac protection and is currently offering a 50% discount on all Intego One plans, allowing users to access the comprehensive package for £2.50 per month for the first two years. It ranks second in the best Mac antivirus solutions and caters to various user needs, from basic protection to extensive security features. The Intego Mac Security X9 suite has received high praise for its antivirus capabilities, with a perfect score of 6 out of 6 from AV-Test for protection, performance, and usability in March 2026. The limited-time offer is available until July 2nd, 2026.

Tech Optimizer

June 18, 2026

Announcing Lakebase Search: agent-native retrieval built into Lakebase Postgres

Lakebase Search is a hybrid vector and full-text retrieval system integrated into Lakebase, now in beta on AWS and Azure. It utilizes two Postgres extensions: lakebase_vector and lakebase_text, allowing agents to operate on a single data backend. Agents manage four times more databases than human users and require real-time access to indexed data. The system features a tiered architecture that stores cold data in cost-effective object storage while keeping active data in local NVMe, significantly reducing costs. The lakebase_vector extension offers 32x compression for vectors, allowing a billion vectors to fit into under 10GB of RAM. The lakebase_text extension provides BM25 relevance ranking without high RAM usage. Benchmarking shows that Lakebase Search can efficiently handle large-scale workloads, achieving high recall and low latency with reduced resource requirements compared to traditional architectures. The system allows for continuous search experimentation and dedicated retrieval engines for each agent, enhancing operational efficiency and scalability.

Tech Optimizer

June 18, 2026

Real-World Threats Demand Real Results

AV-Comparatives conducted its Real-World Protection Test from February to May 2026, assessing 20 consumer security products against real-world internet threats. Seven products received the ADVANCED+ award for their reliable protection capabilities. The complete test report is available for free at av-comparatives.org. The tested products included well-known names such as Avast, AVG, Bitdefender, Kaspersky, Microsoft, Norton, and TotalAV. The test methodology involved evaluating the products against a curated set of threats and assessing false-positive rates.

Tech Optimizer

June 17, 2026

NordVPN celebrates record security scores, including 99.8% detection rate against “high-threat” malware

NordVPN has achieved the "highest possible" AAA rating from West Coast Labs for its protection suite, with a 99.8% detection rate against high-threat malware in real-world Windows 11 environments. It also secured a 96% detection rate with zero false positives in the AV-Comparatives Anti-Phishing test, making it the first VPN provider to earn a protection badge from AV-Comparatives. NordVPN has launched dedicated private VPN servers that offer dedicated hardware, a static IP address, and port forwarding for enhanced user control. Additionally, a recent survey by NordVPN involving over 20,000 participants across 20 countries revealed significant insights into global screen time habits.