NewApp Digest
search bot

storage

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Performance enhancements
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.
Save 75% and Get 3 Free Months on NordVPN + Antivirus (Test Results Included)
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.
pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads
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.
Microsoft Details Windows Clipper Malware Campaign Using USB LNK Worm and Tor-Based C2
Winsage
June 19, 2026

Microsoft Details Windows Clipper Malware Campaign Using USB LNK Worm and Tor-Based C2

Microsoft has identified a Windows-based cryptocurrency clipper campaign that has been active since February 2026. This campaign uses clipboard-intercepting malware with self-spreading capabilities and operates through the Tor network. The clipper malware employs Windows Script Host and ActiveX to launch a Tor proxy and connect to a hidden command-and-control server. It focuses on stealing clipboard data, particularly cryptocurrency wallet addresses, and can exfiltrate screenshots. The malware is distributed via malicious Windows Shortcut (LNK) files on USB drives, which activate a worm that checks for existing infections and fetches the payload from a remote server. The clipper monitors the clipboard every 500 milliseconds for sensitive information and can replace copied wallet addresses with those controlled by attackers. Microsoft recommends behavioral detections, disabling AutoRun for removable media, blocking LNK execution from drives, and monitoring clipboard-related activities as mitigations against this threat.
Commodore's New Flip Phone Skips Android for Linux-Based Sailfish OS
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.
MacBook Neo vs Windows Laptops for Cybersecurity Tasks
Winsage
June 19, 2026

MacBook Neo vs Windows Laptops for Cybersecurity Tasks

The laptop has evolved into a crucial tool for cybersecurity, serving as a workstation for malware analysis and daily operations. A debate exists between the merits of MacBook Neo and Windows-based models, with Windows offering flexibility and compatibility, while macOS is favored for stability and build quality. Popular penetration testing tools are available on both platforms, but Windows laptops have an advantage due to better integration with x86 environments and specialized drivers. Virtualization is essential in cybersecurity, and Windows laptops with higher RAM provide a better experience for running multiple virtual machines compared to the non-upgradable RAM of the MacBook Neo. Intensive tasks can strain systems, necessitating efficient resource management, especially on the MacBook Neo. Most malware is designed for Windows, making it crucial for analysts to be familiar with Windows-specific tools and features. The MacBook Neo is beneficial for tasks like working with event logs and writing automation scripts, while its battery life and mobility are advantageous for professionals on the go. Security considerations play a significant role in the choice of operating system, with Windows being a common target for attackers, whereas macOS has stricter access controls. Windows laptops offer more price flexibility and upgradeability, while the MacBook Neo focuses on simplicity and build quality but lacks upgrade options. Ultimately, Windows is optimal for tasks involving malware analysis and virtual labs, while the MacBook Neo suits those focused on development and network analysis.
Announcing Lakebase Search: agent-native retrieval built into Lakebase Postgres
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.
Why Oracle’s OCI Database with PostgreSQL matters for serious workloads
Tech Optimizer
June 18, 2026

Why Oracle’s OCI Database with PostgreSQL matters for serious workloads

Oracle has launched the OCI Database with PostgreSQL, a managed PostgreSQL service designed for seamless deployment within the Oracle Cloud. This service includes lifecycle management, automated backups, and monitoring, allowing users to customize their database configurations easily. A key feature is the cross-region warm standby, which enhances disaster recovery by enabling users to create replica databases in secondary regions that replicate data from the primary database. The service enforces a strict 5-minute recovery point objective (RPO) and simplifies the setup process for operations teams. The OCI Database with PostgreSQL is positioned against offerings from AWS and Azure, targeting organizations that prefer a managed PostgreSQL experience. However, compliance challenges, such as the lack of FedRAMP certification, may hinder adoption for certain sectors. The product is available on OCI with usage-based pricing and is aimed at cloud teams needing managed operations and disaster recovery for PostgreSQL databases.
Search