| From: | Peter Geoghegan <pg(at)heroku(dot)com> |
|---|---|
| To: | Master ZX <zx-master(at)bigmir(dot)net> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Re[2]: [BUGS] BUG #13869: Right Join query that never ends |
| Date: | 2016-01-19 00:47:02 |
| Message-ID: | CAM3SWZStEZB_UmM2AjOqDEb2_9K3qtT49iy0GXG6M8=g0=HUZQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Sat, Jan 16, 2016 at 4:51 AM, Master ZX <zx-master(at)bigmir(dot)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 first order.
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-01-19 00:47:27 | Re: about CREATE EXTENSION error |
| Previous Message | Dean Rasheed | 2016-01-18 20:06:54 | Re: BUG #13863: Select from views gives wrong results |