partitioning Archives

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.

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.

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.

Tech Optimizer

November 20, 2025

How to implement Dynamic SQL in PostgreSQL 10

Dynamic SQL in PostgreSQL allows developers to streamline querying processes and reduce repetitive tasks. It is implemented using the EXECUTE statement, which evaluates a string input. Dynamic SQL can be used for executing DDL statements, such as analyzing tables within a schema, and for DML statements, enabling interactive data manipulation, like filtering results in a billing application. PL/pgSQL caching can lead to inefficiencies in dynamic SQL scenarios where execution plans vary. Security risks, particularly SQL injection vulnerabilities, are associated with dynamic SQL. Recommended practices to mitigate these risks include using the USING clause for parameterized statements, employing the format function for query construction, and utilizing functions like quote_ident() and quote_literal() for proper formatting.

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.

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.

Winsage

October 5, 2025

How to switch your Windows 10 PC to Linux Mint – for free

The countdown for Windows 10 support is underway, prompting users to consider alternatives like Linux Mint, especially if they are hesitant about upgrading to Windows 11 or if their hardware does not meet the requirements. Linux has become more user-friendly, and Linux Mint is recommended for both newcomers and experienced users. To switch to Linux Mint, users need a Windows PC, an internet connection, and a USB stick with at least 4GB of storage, with an estimated installation time of about 2 hours. Users should compile a list of essential programs and check for Linux-compatible alternatives. Many cloud-based applications work on Linux, and Windows 10 can be run within Linux using Oracle VirtualBox for incompatible programs. The installation process involves downloading the Linux Mint ISO from the website, preparing a USB drive, and adjusting the boot order in the BIOS/UEFI settings. Users should disable Secure Boot to ensure a smooth installation. After rebooting, the Mint interface will appear, and the installation wizard will guide users through the setup process, including language preferences and partitioning the hard drive. Enabling Timeshift for system backups and using the Backup Tool for personal files is recommended. After installation, users should check for additional drivers and install multimedia codecs. Linux Mint requires a minimum of 2GB of RAM and 20GB of disk space and is compatible with most modern hardware. Running both Linux Mint and Windows on the same PC is possible, either by dual-booting or using a virtual machine. Most modern hardware is compatible with Linux, and testing Mint through a live session on a USB stick can confirm compatibility. Software-as-a-service applications generally work well on Linux, while older programs may require additional tools. Many popular applications are available on Linux, and Steam-based games perform well.

Winsage

October 3, 2025

How to switch your Windows 10 PC to Linux Mint

Windows 10 support is ending, prompting users to consider alternatives like Linux Mint, which is compatible with PCs running Windows 10 and allows exploration without altering the existing setup. To switch to Linux Mint, users need a Windows PC, internet connection, and a USB stick or DVD-RW with at least 4GB of storage, with an estimated installation time of about 2 hours. Users should back up important files before installation and may need to disable Windows Fast Startup, BitLocker, and Secure Boot for a smoother transition. Linux Mint requires 2GB of RAM (4GB recommended) and 20GB of disk space (100GB recommended), and it can run on older machines. Most modern hardware is compatible with Linux, and many cloud-based applications like Microsoft 365 work on Linux. Users can test Mint in a live session before installation to check hardware compatibility.

AppWizard

October 1, 2025

How to enable TPM, Secure Boot, HVCI, and VBS for Battlefield 6 and Black Ops 7

Battlefield 6 requires gamers to meet advanced security requirements to access the game, including TPM 2.0, Secure Boot, HVCI, and VBS. TPM 2.0 is a hardware-based security feature found on most modern motherboards, and if absent, users may need to research their motherboard for upgrade options. Secure Boot and TPM 2.0 can be checked using the Steam beta client or through the Device Manager and System Information panel. If disabled, they can typically be enabled via the BIOS/EFI system. Windows must operate in UEFI mode with the GUID partition table for these features to function correctly, and if installed in legacy mode, reinstallation may be necessary. HVCI protects against malicious code and can be checked via the memory integrity settings. VBS can be verified through the System Information panel, indicating if it is running.

Winsage

September 29, 2025

I used DISM to create a Windows installer with all my apps, and here’s how it works

To back up a Windows 11 image, start with a fresh installation and use the Sysprep tool to generalize the system, avoiding Microsoft Store apps to prevent Sysprep failure. Prepare two external drives: one for storing the Windows image (minimum 8GB) and another bootable drive configured with Windows Preinstallation Environment (Windows PE). Download the Windows Assessment and Deployment Kit (ADK) and the Windows PE add-on to create the bootable USB drive. Enter Audit Mode by pressing Ctrl+Shift+F3 at the out-of-box experience screen, disable app updates, and install desired applications for the entire system. Use Sysprep to enter Out of Box Experience (OOBE), check Generalize, and select Shutdown. Boot from the Windows PE drive, use diskpart to identify drive letters, and capture the image with the DISM command. To apply the image on a new PC, create a diskpart script for partitioning and a batch script for applying the image. Boot the new PC from the Windows PE drive, run the diskpart script to create partitions, and execute the batch script to apply the image. This method is efficient for deploying consistent applications across multiple PCs.