Home > mailing lists

Avoid useless retrieval of defaults and check constraints in pg_dump -a - Mailing list pgsql-hackers

From	Julien Rouhaud
Subject	Avoid useless retrieval of defaults and check constraints in pg_dump -a
Date	July 12, 2020 08:48:50
Msg-id	20200712054850.GA92357@nol Whole thread Raw
Responses	Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a (Justin Pryzby <pryzby@telsasoft.com>) Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a (Daniel Gustafsson <daniel@yesql.se>)
List	pgsql-hackers

Tree view

Hi,

Currently, getTableAttrs() always retrieves info about columns defaults and
check constraints, while this will never be used if --data-only option if used.
This seems like a waste of resources, so here's a patch to skip those parts
when the DDL won't be generated.

Attachment

v1-pg_dump_data_only.diff

pgsql-hackers by date:

From: "David G. Johnston"
Date: 12 July 2020, 08:26:22
Subject: Re: Default setting for enable_hashagg_disk

From: Rafia Sabih
Date: 12 July 2020, 12:57:29
Subject: Re: Parallel copy

Avoid useless retrieval of defaults and check constraints in pg_dump -a - Mailing list pgsql-hackers

Attachment

Previous

Next