Skip to content

Xata Blog company blog

Speeding up PostgreSQL dump/restore snapshots

by Esther Miñano Sanz xata.io published 2025-07-01

How targeted improvements helped us speed up bulk data loads and complex schemas.

Read on xata.io → Discuss on HN (41) Archived copy

Points: 156
HN comments: 41
Submissions: 1
Cited by: 0 commenters

Databases & Data Systems & Performance 2025

On Hacker News

Submitted	Title on HN	Points	Comments
Jul 5, 2025	Speeding up PostgreSQL dump/restore snapshots by tudorg	156	41

More from Xata Blog

All 9 posts →

Creating a search engine with PostgreSQL

2023530 points173 comments Databases & Data details

Pgroll: zero-downtime, reversible schema migrations for Postgres

2023328 points149 comments Databases & Data details

Postgres Webhooks with Pgstream

2024160 points21 comments Databases & Data details

Introducing pgzx: create PostgreSQL extensions using Zig

2024156 points37 comments Databases & Data details

File Attachments: Databases can now store files and images

2023130 points102 comments Databases & Data details

How to Distribute Postgres Geographically

2024129 points15 comments Databases & Data details

Related posts from the same era

ICE using Palantir tool that feeds on Medicaid data

EFF Deeplinks20261,475 points969 comments details

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

Tracking down the 16-year-old WAL-reset SQLite bug

Tailscale Blog20261,223 points239 commentscited by 3 details

GPT in 500 Lines of SQL

Explain Extended20241,111 points76 commentscited by 3 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

PGSimCity - How PostgreSQL Works

nikolays.github.io2026930 points90 comments details