data retrieval Archives

Tech Optimizer

June 24, 2026

Latest EnterpriseDB features unify data for AI development

EnterpriseDB is addressing challenges in AI development projects, particularly data sprawl, by introducing features in the EDB Postgres AI platform. The platform now includes Converged Analytics, which bridges operational and analytical data without complex ELT pipelines, and the Agentic Database, which transforms the system into an autonomous database that proactively manages over 200 metrics. These innovations aim to consolidate various data types into a single governed platform, reducing complexity and costs associated with database administration. The update also introduces governance capabilities at the data layer, expected to be available in the latter half of 2026, and a bring-your-own-cloud option for applying AI to data. Customer feedback has influenced these developments, highlighting the need for reduced manual intervention in data management.

Tech Optimizer

June 20, 2026

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements

PostgreSQL version 18 has deprecated MD5 password authentication in favor of SCRAM-SHA-256, with a new parameter, md5_password_warnings, enabled by default to log deprecation warnings. It has enhanced monitoring capabilities by adding columns to pg_stat_database and pg_stat_statements to track parallel worker activity, with the default max_parallel_workers_per_gather set to 0 in Aurora PostgreSQL. The pg_stat_subscription_stats view now includes new columns for tracking conflict types in logical replication. Optimizer statistics are automatically transferred during upgrades, while uuidv7() generates timestamp-ordered UUIDs. The default streaming option for CREATE SUBSCRIPTION has changed to parallel, and the idle_replication_slot_timeout parameter automatically invalidates inactive replication slots. Enhancements to the COPY command include REJECT_LIMIT for error tolerance and a silent LOG_VERBOSITY level. OLD and NEW aliases have been introduced in RETURNING clauses for various DML commands.

Winsage

April 20, 2026

Windows 11 to get a major reliability update in May with faster clipboard, stable taskbar, storage and more

Microsoft has released new Insider builds for Windows 11 across various channels, focusing on enhancing reliability and performance. Key components receiving updates include: 1. File Explorer: Improved speed and reliability, retaining customized folder views. 2. Settings App: Enhanced navigation and consistency, particularly in the Installed Apps page and Privacy & Security section. 3. Drop Tray: Optimized for better usability during multitasking. 4. Clipboard History: Performance enhancements to reduce access delays. 5. Storage Settings: Improved performance for large storage volumes, enabling instant loading of the Disks & Volumes page. 6. Windows Hello: Enhanced fingerprint and face recognition reliability, maintaining biometric data across upgrades. 7. Input and Voice Dictation: Improved keyboard navigation and persistent voice typing settings. 8. Startup Applications: Refined performance and memory management for faster boot times. 9. Display, Audio, and Font Rendering: Better stability and compatibility for color profiles, audio drivers, and font legibility. 10. Security Enhancements: Improved trust model for third-party drivers and command-line scripts. These updates are expected to be available to regular users in the upcoming April optional update and the mandatory May security update.

Tech Optimizer

April 15, 2026

Postgres to Iceberg in 13 minutes: How Supermetal compares to Flink, Kafka Connect, and Spark

Supermetal introduced Iceberg sink support, allowing for data transfer from Postgres to Iceberg. In a performance comparison, Supermetal completed snapshotting in 13 minutes, while Flink took 90 to 116 minutes, Kafka Connect required 120 minutes, and Spark exceeded 3 hours. The tests focused on throughput during the snapshotting phase rather than latency. The setup used the TPC-H dataset with a scale factor of 50 and involved AWS infrastructure. Supermetal operates independently of Kafka, enabling direct data delivery from source to sink. It utilizes a JSON configuration file for deployment, supporting various catalogs and advanced configuration options. Supermetal's Iceberg writer can adjust settings based on the CDC source phase. Throughout the tests, Supermetal maintained low CPU and memory usage, while other tools faced challenges with performance and resource management. Data synchronization was validated across all tools, with Supermetal achieving at least 7x faster snapshotting performance without tuning.