Re: Possible performance regression with pg_dump of a large number ofrelations - Mailing list pgsql-hackers

From Luke Cowell
Subject Re: Possible performance regression with pg_dump of a large number ofrelations
Date
Msg-id 925EA938-B271-432C-A486-534B051196F7@gmail.com
Whole thread Raw
In response to Re: Possible performance regression with pg_dump of a large numberof relations  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Possible performance regression with pg_dump of a large numberof relations
List pgsql-hackers

> On Jan 24, 2018, at 2:56 PM, Stephen Frost <sfrost@snowman.net> wrote:
>
> Hi there!
>
>
>>> ERROR:  relation "pg_init_privs" does not exist
>>> LINE 139: LEFT JOIN pg_init_privs pip
>
> I certainly hope that works on 9.6, since that's when pg_init_privs was
> added..

My mistake. That error is from my 9.5 server. It does error on 9.6, but I get the following error:

$ psql --version
psql (PostgreSQL) 9.6.6
$ psql postgres < query.sql
ERROR:  function pg_get_partkeydef(oid) does not exist
LINE 126: pg_get_partkeydef(c.oid) AS partkeydef,
          ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

> Presuming I can make it work, the idea would be to back-port it to 9.6
> and 10, since pg_init_privs and this code was added in 9.6.

A 9.6 backport would be excellent.

Thanks again!

Luke

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] [POC] Faster processing at Gather node
Next
From: Nikolay Shaplov
Date:
Subject: Re: [PATCH][PROPOSAL] Refuse setting toast.* reloptions when TOAST table does not exist