| From: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> |
|---|---|
| To: | "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> |
| Cc: | CAPmGK15eY_P5AEC6-HjZusx2euftT0KD94ywaeJ=f3NGTLJEFw(at)mail(dot)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: The case when AsyncAppend exists also in the qual of Async ForeignScan |
| Date: | 2021-07-28 08:28:09 |
| Message-ID: | CAPmGK16CLwX-_3xzsPG-kDdtJ+RhSU=EuePQGpCSQqQw_4AUEw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, Jul 28, 2021 at 3:39 PM Andrey V. Lepikhov
<a(dot)lepikhov(at)postgrespro(dot)ru> wrote:
> On 7/27/21 3:50 PM, Etsuro Fujita wrote:
> > On Tue, Jul 27, 2021 at 3:22 PM Andrey V. Lepikhov
> > <a(dot)lepikhov(at)postgrespro(dot)ru> wrote:
> > Here is an updated version of the patch, in which I added/tweaked
> > comments a bit further. I'm planning to push this version if there
> > are no objections from others.
> I used this patch in TPC-H benchmark (that caused initial error) and it
> finished without problems.
Good to know!
> Queries and their explains are attached. You could look for situations
> when async append was not used.
Interesting! Yeah, async exection doesn't apply to Merge Append, so
let's improve to support async-aware Merge Append.
Thanks for the testing!
Best regards,
Etsuro Fujita
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2021-07-28 13:40:25 | Re: BUG #17125: Operator precedence bug in websearch_to_tsquery function |
| Previous Message | Andrey V. Lepikhov | 2021-07-28 06:39:35 | Re: The case when AsyncAppend exists also in the qual of Async ForeignScan |