I've been troubleshooting an issue with slow pg_dump times on postgres 9.6.6. I
believe something changed between 9.5.10 and 9.6.6 that has made dumps
significantly slower for databases with a large number of relations. I posted
this in irc and someone suggested that I should post this here. I'm
> On Jan 12, 2018, at 8:01 AM, Jeff Janes wrote:
>
> On Thu, Jan 11, 2018 at 5:26 PM, Luke Cowell <mailto:lcow...@gmail.com>> wrote:
> I've been troubleshooting an issue with slow pg_dump times on postgres 9.6.6.
> I believe something changed between 9.5.10
Hi Stephen, thank you for putting this together.
> If folks get a chance to take a look at the query and/or test, that'd be
> great. I'll try to work up an actual patch to pg_dump this weekend to
> run it through the regression tests and see if anything breaks.
I'm not sure how I can help other
> On Jan 24, 2018, at 2:56 PM, Stephen Frost 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 ser
