Re: pg_dump (COPY) hanging intermittently

2019-07-04 Thread Ben Snaidero
On Thu, Jun 27, 2019 at 3:19 PM Tom Lane wrote: > Ben Snaidero writes: > > Do these stack traces shed help at all? > > None worth mentioning :-(. Can you rebuild with debug symbols? > > regards, tom lane > So I've rebuilt with debug symbols and for some reason I am now

Re: pg_dump (COPY) hanging intermittently

2019-06-27 Thread Tom Lane
Ben Snaidero writes: > Do these stack traces shed help at all? None worth mentioning :-(. Can you rebuild with debug symbols? regards, tom lane

Re: pg_dump (COPY) hanging intermittently

2019-06-27 Thread Ben Snaidero
On Thu, Jun 27, 2019 at 2:34 PM Tom Lane wrote: > Ben Snaidero writes: > > I am running into a strange issue with Postgres 10 when using pg_dump > with > > the directory format and jobs parameter set it intermittently hangs. > Seems > > to occur less frequently the lower I set the jobs parameter

Re: pg_dump (COPY) hanging intermittently

2019-06-27 Thread Tom Lane
Ben Snaidero writes: > I am running into a strange issue with Postgres 10 when using pg_dump with > the directory format and jobs parameter set it intermittently hangs. Seems > to occur less frequently the lower I set the jobs parameter but does happen > eventually even when set to 2 (could not r