SShortSingh.
Back to feed

Postgres 19 Adds Faster Built-In Table Bloat Cleanup via Repack

0
·2 views

A Snowflake engineering blog post describes a built-in table repacking feature planned for Postgres 19 that targets table bloat. The approach is presented as faster than existing methods for reclaiming space in bloated tables. The post frames the change as a native cleanup capability within Postgres rather than an external tool. The available source material is limited to the article link and a brief Hacker News listing, so details beyond the headline and the blog post's premise cannot be confirmed here.

Read the full story at Hacker News

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

Eclipse Enclave 1.0 Launches Open-Source Sandbox for AI Coding Agents

The Eclipse Foundation released Enclave 1.0 on 19 November 2026, a free, MIT-licensed sandbox that runs each AI coding agent in its own isolated container. Users control which files, network hosts and secrets the agent can access, letting it work autonomously without prompts while keeping the host machine protected. The tool is vendor-neutral and ships with six agents built in, including Claude Code, Codex and GitHub Copilot CLI. It grew out of internal tooling at EclipseSource, which contributed it to the Foundation in July 2026. A gateway component filters outbound traffic against an allowlist and logs both allowed and blocked attempts for auditing.

0
ProgrammingDEV Community ·

Only 41 of 90 new article pairs are ready to publish, all for Zenn

A production ledger check at commit 6fe4649 on September 11, 2026 found 136 Japanese and English files forming 68 bilingual pairs, but only 41 pairs are fully complete with resolved URLs. The remaining 27 pairs lack canonical article IDs, and 22 candidates still need body verification. All 41 completed pairs target Zenn, while none are complete for Qiita. Under a hypothetical schedule of one Zenn pair per day, the stock covers 41 consecutive days, but allocating two Zenn pairs daily yields only 20 days. The existing publishing schedule contains no rows on or after September 11, so none of the new candidates has been scheduled yet.

0
ProgrammingDEV Community ·

hexbin-heatmap: aggregating points into H3 hexagons and geohash cells, in the browser and CLI

Plotting tens of thousands of points on a map makes dense areas collapse into a solid blob, hiding how many points each location holds. The usual remedy is to aggregate points into grid cells and color those cells instead, though choosing a grid, scaling colors across wide value ranges, and handling cells that cross the 180° meridian add complexity. The open-source hexbin-heatmap project tackles these issues by binning CSV or GeoJSON points into H3 hexagons or geohash cells and rendering them as a choropleth in MapLibre with a resolution slider. The same aggregation logic is also available as a command-line tool that outputs GeoJSON or CSV, with each cell carrying count, sum, and mean values. The web app runs entirely in the browser so files are never uploaded, and the project includes setup instructions for local development, testing, and building.

0
ProgrammingDEV Community ·

nord-sahara-wgs84: a step-by-step Python tool for converting Algerian Nord Sahara 1959 coordinates to WGS 84

Many Algerian maps, survey plans and well reports record coordinates in the Nord Sahara 1959 datum, which is based on the Clarke 1880 ellipsoid, while GPS devices and web maps use WGS 84. Plotting Nord Sahara points on a WGS 84 map without conversion puts them in noticeably wrong locations. The author built nord-sahara-wgs84, a dependency-free Python library and command-line tool that carries out the conversion step by step and checks each figure against PROJ. It covers datum transformations in both directions, UTM projections for zones 29N to 32N on both datums, and all ten published Helmert transformations from the EPSG database, which Nord Sahara 1959 lacks grid files for. The tool is intended as an educational project for making the underlying mathematics readable, and it requires Python 3.13 or newer.