Postgres Pro
Downloads
Home   >   mailing lists

Re: Add semi-join pushdown to postgres_fdw - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: Add semi-join pushdown to postgres_fdw
Date
Msg-id CAPpHfdsgBv+O9NL6sE=ifJY=6uvdbLLgknPp9UqwELAiDjjPwQ@mail.gmail.com
Whole thread Raw
In response to Re: Add semi-join pushdown to postgres_fdw  (Pavel Luzanov <p.luzanov@postgrespro.ru>)
Responses Re: Add semi-join pushdown to postgres_fdw
List pgsql-hackers
Tree view 
Hi, Pavel!


On Fri, Feb 9, 2024 at 10:08 PM Pavel Luzanov <p.luzanov@postgrespro.ru> wrote:
> But optimization not used for NOT EXISTS:

Right, anti-joins are not supported yet.

> Also, optimization not used after deleting first condition (a.aircraft_code = '320'):

This is a costing issue.  Optimization worlds for me when set
"use_remote_estimate = true" for the server;

> But the worst thing is that replacing AND with OR causes breaking session and server restart:

I haven't managed to reproduce this yet.  Could you give more details:
machine, OS, compile options, backtrace?

------
Regards,
Alexander Korotkov

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Printing backtrace of postgres processes
Next
From: Amit Kapila
Date:
Subject: Re: Improve documentation of upgrade for streaming replication section.