Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-09-15T02:33:20Z
Lists: pgsql-hackers
On Tue, Jul 14, 2020 at 11:14:50AM +0200, Julien Rouhaud wrote: > Note that those extraneous queries were found while trying to dump > data out of a corrupted database. The issue wasn't an excessive > runtime but corrupted catalog entries, so bypassing this code (since I > was only interested in the data anyway) was simpler than trying to > recover yet other corrupted rows. Yeah, I don't see actually why this argument can prevent us from doing a micro optimization if it proves to work correctly. -- Michael
Commits
-
Avoid retrieval of CHECK constraints and DEFAULT exprs in data-only dump
- 5423853feebd 14.0 landed