FlareStart
HomeNewsHow ToSources
FlareStart

Where developers start their day. All the tech news & tutorials that matter, in one place.

Quick Links

  • Home
  • News
  • Tutorials
  • Sources
  • Privacy Policy

Connect

© 2026 FlareStart. All rights reserved.

Back to articles
NewsSystems

PGTune Update: NVMe support, PG18 async I/O, and data-size-aware memory tuning

via Reddit Programming/u/le0pard9h ago

Hey everyone, I recently put together a major update for the pgtune app to bring its math into the modern PG18. Here is a quick breakdown of what was added: PostgreSQL 18 async I/O: Dynamically scales io_workers (capped at 25% of CPU cores) and routes io_method to io_uring on Linux and worker everywhere else NVMe storage profile: Added a dedicated NVMe storage option, which safely bumps effective_io_concurrency up to 1000 on Linux to exploit deep parallel I/O queues Database size vs. RAM: Added a new input to compare total data size to RAM. If your DB fits entirely in memory, it safely boosts work_mem by 30%. If the DB is massively larger than RAM, it shrinks work_mem by 10% to protect the OS page cache from eviction pressure Modern RAM & Strict OS Guards: Safely raised maintenance_work_mem limits to 8GB for massive servers, but implemented strict OS-level guards to prevent the 2GB integer overflow crash on Windows (for PG 17 and older) Safer Defaults: Implemented a hard 4MB floor on w

Continue reading on Reddit Programming

Opens in a new tab

Read Full Article
3 views

Related Articles

News

FRACTRAN: A Simple Universal Programming Language for Arithmetic

Reddit Programming • 12m ago

ROSCOE: A Suite of Metrics for Scoring Step-by-Step Reasoning
News

ROSCOE: A Suite of Metrics for Scoring Step-by-Step Reasoning

Dev.to • 1h ago

If you thought the speed of writing code was your problem - you have bigger problems
News

If you thought the speed of writing code was your problem - you have bigger problems

Lobsters • 4h ago

News

Negative 2000 Lines Of Code

Reddit Programming • 5h ago

News

My experience with SurrealDB starting with v0.3 in February 2023, all the way up to v3 in 2026

Reddit Programming • 6h ago

Discover More Articles