ppened or how I can fix this issue?
I had the issue once on another server and running VACUUM FULL on entire
database fixed the error.
Note: I ran "VACUUM FREEZE ANALYZE" before the upgrade on every database
and there were no errors.
Ben Snaidero
*Geotab*
Senior Database Specialist
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 sym
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
PostmasterMain+0x275
postgres.exe!main+0x480
postgres.exe!pgwin32_popen+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.
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
> expon
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 (
nodeobje
