Aug 2021

2 commits
In pg_dump, avoid doing per-table queries for RLS policies.
31 Aug 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14rc1REL_13_STABLE13.5+4 more
LLM analysis, 100% surelanded as postedfrom patchset #211 of 1 reviewer saw the final version

The diff for bd3611db5a exactly matches #21 after removing Git index metadata, including the bulk pg_policy query and policy-to-table mapping in src/bin/pg_dump/pg_dump.c.

  • hubert depesz lubaczewskisaw the final versionLLM analysis, 100% sureTesting #21 on top of the initial type-name patch reduced queries from 4178 to 3884 and dump time from 8m12s to 7m35s, as reported before the commit in #26.
Cache the results of format_type() queries in pg_dump.
31 Aug 2021Tom Lanemaster15beta1REL_19_STABLE15beta1REL_18_STABLE15beta1REL_17_STABLE15beta1REL_16_STABLE15beta1REL_15_STABLE15beta1REL_14_STABLE14rc1REL_13_STABLE13.5+4 more
LLM analysis, 100% surelanded as postedfrom patchset #321 of 2 reviewers saw the final version

The diff for 6c450a861f exactly matches #32 after removing Git index metadata, including lazy cache initialization, lookup, and population in src/bin/pg_dump/pg_dump.c and the TypeInfo field in pg_dump.h.

  • Stephen Frostsaw an earlier versionLLM analysis, 100% sureStephen reported a quick review of #12, said the changes looked good, and explained the latency benefit in #14, before the switch from preloading to on-demand caching.
  • hubert depesz lubaczewskisaw the final versionLLM analysis, 100% sureHubert tested the initial patch and compared dump contents in #26, then tested the committed version #32 and reported a reduction to 4261 queries in #33.

Credits across 2 commits

Author
Tom LaneLLM2
Committer
Tom Lane2

N LLM means N of the credits come from LLM analysis, not from commit trailers.