NewApp Digest
search bot

partitioning

Windows NT on the GameCube is Basically a Homebrew Project That Brings the Classic OS to Nintendo Hardware
Winsage
June 12, 2026

Windows NT on the GameCube is Basically a Homebrew Project That Brings the Classic OS to Nintendo Hardware

GameCube enthusiasts are utilizing homebrew projects to enhance the console's capabilities, including region-free play and disc backups. A new initiative allows a full PowerPC build of Windows NT to run on the GameCube, leveraging its Gekko CPU's compatibility with early PowerPC-based PCs. The entii-for-workcubes project, led by Wack0, provides components for running Windows NT 3.51 or 4.0 on GameCube and Wii systems, featuring an ARC firmware bootloader for loading homebrew software. Users need to prepare an SD card with specific files and a Windows NT ISO to initiate the process. After installation, basic productivity tools are accessible, but limitations include only 24MB of RAM, slower access speeds, lack of sound support, and potential reboot stalls.
Azure HorizonDB Enters Public Preview: Web IQ Already Powers Copilot and ChatGPT
Tech Optimizer
June 6, 2026

Azure HorizonDB Enters Public Preview: Web IQ Already Powers Copilot and ChatGPT

Microsoft announced the public preview of Azure HorizonDB, a fully managed PostgreSQL-compatible database designed for agentic AI workloads, during Microsoft Build 2026 in San Francisco. HorizonDB features a "database-as-logs" architecture, allowing for sub-millisecond multi-zone commit latency and independent scaling of compute and storage. It incorporates a Rust-based storage engine, native DiskANN vector search, and in-database AI model invocation. Additionally, Microsoft launched Web IQ, a web-grounding API layer integrated into Microsoft Copilot and OpenAI's ChatGPT, which provides passage-level structured evidence objects rather than full documents. Web IQ is model-agnostic and aims to enhance information density and reduce costs. Both services are currently in limited availability, with HorizonDB open for preview signups across five Azure regions.
Absurd Delivers Durable Workflows On Postgres
Tech Optimizer
May 3, 2026

Absurd Delivers Durable Workflows On Postgres

On April 4, 2026, Earendil reported on Absurd, an execution system built solely on Postgres, which has been in production for five months and has received several updates. Recent developments include the introduction of Software Development Kits (SDKs) for TypeScript, Python, and an experimental Go SDK, as well as a command-line interface (CLI) called absurdctl and a Habitat dashboard for monitoring and management. Absurd's architecture is resilient, utilizing a checkpointed step model for durable agent workflows, but currently lacks features like partitioning and built-in push scheduling, focusing on reliability and simplicity.
This is probably the first mainstream mini PC that can dual-boot Ubuntu and Windows out of the box — and it even comes with the hottest AI application of 2026
Winsage
March 26, 2026

This is probably the first mainstream mini PC that can dual-boot Ubuntu and Windows out of the box — and it even comes with the hottest AI application of 2026

GMKtec has launched the NucBox K13 mini PC, which supports dual-booting of Windows 11 Pro and Ubuntu. It features an Intel Core Ultra 7 256V processor with eight cores up to 4.8GHz and an Intel Arc 140V GPU. The device offers 16GB of LPDDR5X RAM, dual M.2 SSD slots for up to 16TB of storage, Wi-Fi 6E, and five-gigabit LAN. It supports triple 4K display outputs and includes various ports such as USB 3.2 Gen2, USB4, HDMI 2.1, and a 5Gbps RJ45 LAN port. Concerns have been raised about the AI tool OpenClaw, which has known vulnerabilities and has been linked to malware, leading Microsoft to advise against its use on personal or enterprise systems.
Building a High-Performance Postgres Time Series Stack with Iceberg
Tech Optimizer
March 19, 2026

Building a High-Performance Postgres Time Series Stack with Iceberg

Postgres extensions, specifically pg_lake, pg_partman, and pg_incremental, provide a vendor-agnostic, open-source solution for managing high-performance time series data. PostgreSQL serves as the foundation, while pg_partman automates time partition management, pg_lake connects Postgres with data lakes for offloading cold data, and pg_incremental processes append-only data in batches. These extensions are maintained by the Postgres team at Snowflake. An example system for monitoring temperature readings uses local storage for recent data and transitions cold data to an Apache Iceberg table on S3. The process includes creating a partitioned table in Postgres, establishing an Iceberg table, using pg_incremental for data appending, eliminating old partitions with pg_partman, and querying from both local and cold tables to optimize storage and costs. A time-partitioned table enhances performance by allowing efficient deletion of outdated data, speeding up queries, and reducing fragmentation.
How OpenAI Scaled to 800 Million Users on PostgreSQL
Tech Optimizer
February 19, 2026

How OpenAI Scaled to 800 Million Users on PostgreSQL

OpenAI has scaled PostgreSQL to support over 800 million active users of ChatGPT, making it one of the largest PostgreSQL deployments globally. The database can handle millions of concurrent connections and a very high volume of requests per second. OpenAI employs several strategies to optimize performance: 1. **Connection Pooling with PgBouncer**: Reduced database connections from 10,000 to 200, enhancing efficiency by a factor of 50. 2. **Read Replicas**: Distributes read requests across multiple replicas while the primary database handles writes. 3. **Horizontal Sharding**: Partitions data across multiple instances based on a shard key, such as user_id or tenant_id. 4. **Query Optimization**: Analyzes slow queries and creates appropriate indexes to maintain performance. 5. **Connection Management**: Implements timeouts and connection limits to prevent overload. 6. **Caching**: Uses application-level caching with Redis to reduce database load. 7. **Monitoring and Observability**: Tracks key metrics like connection counts and query latency to identify issues early. These strategies enable OpenAI to maintain performance and reliability for a large user base.
PostgreSQL 13’s Sunset: Why Database Pros Must Upgrade Before the Lights Go Out
Tech Optimizer
November 7, 2025

PostgreSQL 13’s Sunset: Why Database Pros Must Upgrade Before the Lights Go Out

Organizations using PostgreSQL 13 must upgrade before its end-of-life on November 13, 2025, as this will result in the cessation of security patches, bug fixes, and official support. Continuing to use an unsupported version exposes systems to vulnerabilities, which can lead to data breaches and compliance challenges. The last minor release for PostgreSQL 13 was 13.21 in May 2025. Upgrading to newer versions, such as PostgreSQL 16 or 17, offers performance improvements and enhanced features. Strategies for upgrading include using tools like pg_upgrade, pg_dump/pg_restore, and logical replication to minimize downtime. Compatibility issues may arise due to deprecated functions in PostgreSQL 13, necessitating code reviews. Managed services like those from Percona can provide support beyond EOL. The costs of not upgrading can be significant, with potential downtime from security breaches often exceeding migration expenses.
Meet the Team Behind Snowflake Postgres
Tech Optimizer
November 2, 2025

Meet the Team Behind Snowflake Postgres

In June 2025, Snowflake acquired Crunchy Data to integrate Postgres into its offerings. Crunchy Data, founded in 2012, focused on enhancing Postgres for enterprise environments, creating a security-first distribution called Crunchy Certified PostgreSQL. They introduced the Postgres Operator for Kubernetes in 2017 and launched Crunchy Bridge, a fully managed cloud Postgres service, in 2020. The Crunchy Data team has made significant contributions to the Postgres ecosystem, including enhancements to core functionality and extensions like PostGIS and pg_partman. Key team members have held leadership roles in the PostgreSQL community. Snowflake Postgres aims to unify transactional and analytical workloads, allowing organizations to run applications at scale while leveraging data for analytics, machine learning, and AI.
Search