Re: Re[2]: [BUGS] BUG #13869: Right Join query that never ends - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: Re[2]: [BUGS] BUG #13869: Right Join query that never ends
Date
Msg-id CAM3SWZStEZB_UmM2AjOqDEb2_9K3qtT49iy0GXG6M8=g0=HUZQ@mail.gmail.com
Whole thread Raw
In response to Re[2]: [BUGS] BUG #13869: Right Join query that never ends  (Master ZX <zx-master@bigmir.net>)
Responses Re[2]: [BUGS] Re[2]: [BUGS] BUG #13869: Right Join query that never ends
Re[2]: [BUGS] Re[2]: [BUGS] BUG #13869: Right Join query that never ends
List pgsql-bugs
On Sat, Jan 16, 2016 at 4:51 AM, Master ZX <zx-master@bigmir.net> wrote:
> I can do more to investigate this behavior only if postgresql will consider my claim as bug that has to be fixed in
firstorder. 
> Ideally  I should give my DB schema and dump or VM wich reproduces this bug, but I can not give away our internal
data.All other options I can not describe at public mailing list. 

Why don't you use a tool like Linux's perf to determine where time is spent?:

https://wiki.postgresql.org/wiki/Profiling_with_perf

A simple "perf top" may be all that it takes to give us a better idea
of where time is spent.

--
Peter Geoghegan

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: about CREATE EXTENSION error
Next
From: Michael Paquier
Date:
Subject: Re: BUG #13874: The index of a json field which is created after data are inserted doesn't work.