Re: Request For Feature: pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Request For Feature: pg_dump
Date: 2026-05-22 16:52:59
Message-ID: 26493.1779468779@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ron Johnson <ronljohnsonjr(at)gmail(dot)com> writes:
> In --format=directory mode, remove .dat files with zero data records, and
> mark that table's toc.dat entry that it's an empty table.

> Justification: *lots* of empty tables means *lots* of teeny-tiny files in
> the DB's dump directory. That unnecessarily bloats the fs, and makes "du
> -c" really really slow.

Evidence please? Most file systems that I've looked at optimize
zero-size files pretty well.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2026-05-22 17:20:58 Re: Request For Feature: pg_dump
Previous Message Giovanni Martinez 2026-05-22 14:42:40 Re: Partitioning table - Update on partitioning key