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
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 frequent
n+0x144f
KERNEL32.DLL!BaseThreadInitThunk+0x14
ntdll.dll!RtlUserThreadStart+0x21
Any ideas on changes in Postgres 10 that would cause this? We were
previously running 9.6.7 and didn't encounter this issue on that version
either.
Thanks
Ben.
Ben Snaidero
*Geotab*
Senior Database Specialist
Direct +1 (2
On Thu, Jan 17, 2019 at 4:13 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Jan 17, 2019 at 9:19 AM Ben Snaidero
> wrote:
> > Any ideas as to why this is happening?
>
> Not really, I would expect roughly double execution time, not an
> e
The following query runs as expected.
explain analyze SELECT MainTable.gid AS MainTable_gid,MainTable.datetime AS
MainTable_datetime,MainTable.objectid AS MainTable_objectid,MainTable.type
AS MainTable_type FROM MainTable
WHERE objectid = ANY(ARRAY(SELECT NE.objectid AS entityId FROM (