diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2021-08-31 15:04:05 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2021-08-31 15:04:05 -0400 |
| commit | a20a9f26cefcf4e35ba7bb3d9e8672cb4ce1cf32 (patch) | |
| tree | 748810485910716fd49b32650373e7d28c9db5f3 /src/tutorial/funcs.c | |
| parent | 9407dbbcb5b587cbefc4af14d1612b49abcb143b (diff) | |
| download | postgresql-a20a9f26cefcf4e35ba7bb3d9e8672cb4ce1cf32.tar.gz postgresql-a20a9f26cefcf4e35ba7bb3d9e8672cb4ce1cf32.zip | |
In pg_dump, avoid doing per-table queries for RLS policies.
For no particularly good reason, getPolicies() queried pg_policy
separately for each table. We can collect all the policies in
a single query instead, and attach them to the correct TableInfo
objects using findTableByOid() lookups. On the regression
database, this reduces the number of queries substantially, and
provides a visible savings even when running against a local
server.
Per complaint from Hubert Depesz Lubaczewski. Since this is such
a simple fix and can have a visible performance benefit, back-patch
to all supported branches.
Discussion: https://postgr.es/m/20210826084430.GA26282@depesz.com
Diffstat (limited to 'src/tutorial/funcs.c')
0 files changed, 0 insertions, 0 deletions