NewApp Digest
search bot

operations

A practical guide to cost optimization with Lakebase Postgres
Tech Optimizer
October 11, 2026

A practical guide to cost optimization with Lakebase Postgres

Lakebase is a fully managed Postgres database designed for modern application development, featuring an architecture that separates storage and compute with a serverless compute layer. This design allows for cost efficiencies through various mechanisms: 1. **Branching**: Developers can create isolated environments for development, testing, or experimentation without duplicating storage costs, as branches share the same underlying storage. 2. **Autoscaling**: Lakebase adjusts compute resources based on activity levels, allowing users to pay only for the compute they use. It can scale down during low activity and can be suspended entirely after inactivity, reducing costs to zero. 3. **Read Replicas and High Availability**: The separation of storage and compute allows for adding read replicas and high availability without incurring additional storage costs, as these instances utilize the same storage layer. 4. **Synced Tables**: Integration with the Databricks Intelligence Platform enables efficient data syncing, allowing users to sync only the necessary working set of data, which helps avoid unnecessary storage and sync costs. 5. **Sync Modes**: There are three sync modes (Snapshot, Triggered, Continuous) for transferring data from the Lakehouse to Lakebase, each with different cost implications based on data freshness requirements. 6. **Right-sizing Compute**: Users can set the initial compute range during project provisioning to avoid over-provisioning and unnecessary costs. 7. **Monitoring and Metrics**: The Lakebase Metrics dashboard provides insights into working set size and cache utilization, helping users optimize their compute sizing and performance. 8. **Point-in-Time Restore (PITR) and Snapshots**: PITR maintains history for recovery within a configurable window, while snapshots offer discrete recovery points. Both are priced lower than standard storage, making them cost-effective options for data recovery. Lakebase costs are categorized into compute, storage, and serverless pipeline compute for syncing data. Compute is measured by CU usage, while storage includes branch storage, PITR history, and snapshot storage, all tracked separately. Users can access detailed usage and cost information through system billing tables.
Query Plan Hints in PostgreSQL 19: A New Postgres Feature You Will Probably Never Need
Tech Optimizer
October 11, 2026

Query Plan Hints in PostgreSQL 19: A New Postgres Feature You Will Probably Never Need

PostgreSQL 19 features an advanced query planner that utilizes table statistics from pg_statistic, gathered during the ANALYZE process, to generate and evaluate potential query plans based on their costs. The planner assesses various configurations, especially in complex joins, to select the most efficient option. Instances of poor planning are treated as bugs and addressed promptly. To improve query performance, users are advised to refresh statistics with ANALYZE, use CREATE STATISTICS for column correlations, modify indexes, and adjust memory settings. In cases where the query cannot be altered, providing planner advice may be necessary, particularly when the planner misestimates the output of PL/pgSQL functions or other custom functions, leading to inefficient query execution.
Болгары пользуются зарубежными торрент-сайтами
TrendTechie
October 10, 2026

Болгары пользуются зарубежными торрент-сайтами

Following the closure of Bulgarian torrent sites Zamunda.net, ArenaBG, and Zelka.org, users in Bulgaria have shifted to international torrent platforms. This change was noted by Vladislav Todorov from the General Directorate for Combatting Organized Crime (GDBOC). The shutdown was part of a coordinated international effort involving Europol, GDBOC, the State Agency for National Security (DANS), and U.S. authorities, resulting in the confiscation of domain names after a U.S. court ruling. Four individuals have been arrested in Bulgaria as part of the investigation, but there has been no official communication regarding further steps. After the closures, Bulgaria was removed from the U.S. "301 List" monitoring intellectual property protection issues, while the European Union remains on the list. Todorov warned that downloading from torrent trackers poses cybersecurity risks.
The studio behind Star Wars Zero Company is hiring back some of its furloughed staff
AppWizard
October 10, 2026

The studio behind Star Wars Zero Company is hiring back some of its furloughed staff

Bit Reactor, the developer of Star Wars Zero Company, placed over 80% of its workforce on furlough before the game's launch due to sales uncertainties. Recently, the company announced a gradual return to normal operations, with payroll rebounding to over half of pre-furlough levels. The decision to furlough employees was made independently by Bit Reactor and did not involve its publisher, EA. Despite initial challenges, Star Wars Zero Company became a best seller on Steam and received positive reviews from critics.
Supabase Announces $150M in New Funding and Turso Acquisition
Tech Optimizer
October 10, 2026

Supabase Announces $150M in New Funding and Turso Acquisition

Supabase has secured 0 million in funding led by GIC, with participation from Alphabet's CapitalG, IronArc, and SquarePeg. This follows a million Series F round four months earlier. Supabase has acquired Turso, a platform for managing databases for agentic workloads, to enhance its product development and provide liquidity for employees. The company is adding over 1 million users and 4 million databases monthly, with 70% created by AI-driven tools, reflecting a 600% year-over-year increase in databases. Turso's architecture allows for on-demand provisioning of databases in public cloud and BYOC setups. Glauber Costa, founder of Turso, will become Head of Agentic Services at Supabase. Supabase, established in 2020, supports over 13 million developers with a comprehensive backend solution.
Russian software taught to work more easily with large data arrays
Tech Optimizer
October 10, 2026

Russian software taught to work more easily with large data arrays

Russian Postgres Professional has released an update to Postgres Pro AXE, version 2.0, which allows users to handle analytical data using standard SQL queries instead of specialized stored procedures. This update improves accessibility to analytical data, which is stored in Parquet format and managed through a dedicated metadata catalog. The system is designed for analytical workloads, supporting Online Analytical Processing (OLAP) and hybrid workloads. The first public version of Postgres Pro AXE was launched in January 2026, featuring vectorized analytical queries and compatibility with columnar storage. In the Russian market, alternatives to Postgres Pro AXE include Arenadata DB, optimized for corporate data warehouses, and Arenadata QuickMarts, a clustered columnar DBMS based on ClickHouse for rapid analytics.
How and why we built Managed PostgreSQL for AI workloads
Tech Optimizer
October 10, 2026

How and why we built Managed PostgreSQL for AI workloads

The Nebius Managed PostgreSQL team developed a solution for AI workloads using CloudNativePG and Kubernetes, resulting in improved backup and restore times by transitioning from Barman to WAL-G, reducing a 1.5 TB backup duration from over a day to two hours. Since its launch in 2025, the service supports hundreds of production clusters and manages tens of tebibytes of data. Key features include high availability, point-in-time recovery, automated failover, compressed and encrypted backups, rapid restoration, connection pooling, and strict synchronous replication for zero data loss. Kubernetes and CloudNativePG were chosen for their advantages, including out-of-the-box features and open-source distribution. Each cloud project has a separate MK8s cluster for customer isolation and security. Persistent data is stored on fault-tolerant SSD drives, enabling swift instance migration during failures. Regular physical backups are archived, allowing restoration within a seven-day window with a single click. The transition from Barman to WAL-G addressed slow backup and restoration times and resource control limitations. With WAL-G, backups and restorations for a 1.5 TB cluster improved to two hours and one hour, respectively. PgBouncer was implemented to manage database connections effectively, reducing connection storms during peak AI workload traffic. Two vector search extensions, pgvector and pgvectorscale, are available to cater to different memory and dataset needs. Benchmarking showed that Nebius performs competitively with AWS at a lower cost. The infrastructure integrates cloud engineering principles with specialized expertise to meet AI workload demands.
DBtune autonomous optimization blows PostgreSQL bottlenecks away
Tech Optimizer
October 10, 2026

DBtune autonomous optimization blows PostgreSQL bottlenecks away

DBtune, a startup based in Malmö/Lund, Sweden, was founded in 2020 by Dr. Luigi Nardi as a spin-off from Stanford University and Lund University. The company focuses on enhancing PostgreSQL's capabilities through autonomous database optimization technology and has raised .4 million in a seed round from various investors in July 2023, with support from the Wallenberg Foundation and Vinnova. DBtune's technology utilizes agentic AI for optimizing PostgreSQL databases by tuning server parameters, optimizing indexes, and monitoring autovacuum processes. The release of DBtune version 4.0 incorporates machine learning and AI to dynamically adjust server parameters and suggest optimal indexing strategies. The platform identifies and ranks potential index opportunities based on workload and provides recommendations for new indexes and maintenance of existing ones. A case study with Midwest Tape demonstrated a 10.8x performance improvement in database query runtime after employing DBtune for performance tuning. Benchmarking tests showed a transaction throughput increase of 87% during initial optimization, with a further 17% improvement on an already optimized system. Disk I/O activity was reduced by 43%, and WAL generation decreased by 23%. Dr. Nardi emphasizes the need for AI-driven optimization to manage the complexities of PostgreSQL databases and rising cloud costs, suggesting that significant code adaptations will be necessary for achieving fully autonomous PostgreSQL.
Copilot Gets Control of Windows and Your Files as Microsoft’s Recall Bill Comes Due
Winsage
October 8, 2026

Copilot Gets Control of Windows and Your Files as Microsoft’s Recall Bill Comes Due

Microsoft is requesting Windows users to grant its Copilot feature access to their files and activities, following a previous retraction of a similar AI integration due to scrutiny. Copilot can analyze content on the device with user consent, performing tasks like organizing files and troubleshooting, using both local AI models and cloud processing. Microsoft has implemented safeguards, but its security team has raised concerns about potential risks associated with powerful features. The opt-in nature of Copilot places accountability on Microsoft, as users must actively grant access. Hybrid features are set to roll out in the coming months, with taskbar search actions already reaching Windows Insiders. Over 40 percent of new business laptops are being designed as Copilot+ PCs, with the Surface Laptop Ultra scheduled for release on October 16.
Search