Re: Scans are offloaded to SeqScan instead of CustomScan when there are multiple relations in the same query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Amin <amin(dot)fallahi(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Scans are offloaded to SeqScan instead of CustomScan when there are multiple relations in the same query
Date: 2023-04-18 02:23:20
Message-ID: 2550563.1681784600@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Amin <amin(dot)fallahi(at)gmail(dot)com> writes:
> I made sure EXPLAIN returns CustomScan for all scans in the query. But
> still, ExecCustomScan is only called once while the rest of the functions
> are called for each scan separately. Is this expected behavior? How to work
> around this?

[shrug...] There's some bug in your code, which you've not shown us
(not that I'm volunteering to review it in any detail).

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-04-18 02:35:16 Re: eclg -C ORACLE breaks data
Previous Message Tom Lane 2023-04-18 02:11:09 Re: Fix typos and inconsistencies for v16