Re: Postgresql 10.3 , query never completes if LIMIT clause is specified and paralle processing is on

From: Alessandro Aste <alessandro(dot)aste(at)gmail(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql 10.3 , query never completes if LIMIT clause is specified and paralle processing is on
Date: 2018-03-23 08:31:26
Message-ID: CAM9F+O2AjdNMY_mzLtTa=SMpSayWicry4kzy38zjns1QmYKb7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tomas, I'm attaching a 4MB file with the perf report. Let me know if it
gets blocked, I'll shrink it to the first 1000 lines.

Thank you,

Alessandro.

On Thu, Mar 22, 2018 at 11:42 PM, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com
> wrote:

> On 03/22/2018 11:29 PM, Alessandro Aste wrote:
> > Thanks Tomas. We're currently building postgres from source. In order to
> > enable symbols, you want me to re-configure postres with --enable-debug
> > then run perf?
> >
>
> Yes.
>
> regards
>
> --
> Tomas Vondra http://www.2ndQuadrant.com
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

Attachment Content-Type Size
report.txt text/plain 4.2 MB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2018-03-23 09:23:13 Re: primary key and unique index
Previous Message David Rowley 2018-03-23 08:10:40 Re: primary key and unique index