Re: Scans are offloaded to SeqScan instead of CustomScan when there are multiple relations in the same query - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Scans are offloaded to SeqScan instead of CustomScan when there are multiple relations in the same query
Date
Msg-id 2525827.1681771533@sss.pgh.pa.us
Whole thread Raw
In response to Re: Scans are offloaded to SeqScan instead of CustomScan when there are multiple relations in the same query  (Amin <amin.fallahi@gmail.com>)
Responses Re: Scans are offloaded to SeqScan instead of CustomScan when there are multiple relations in the same query
List pgsql-hackers
Amin <amin.fallahi@gmail.com> writes:
> To simplify: Can CustomScan scan multiple relations in the same query or it
> will always be assigned to one or zero relations?

There's barely any code in the core planner that is specific to custom
scans.  Almost certainly this misbehavior is the fault of your
custom-path-creation code.  Maybe you're labeling the paths with the
wrong parent relation, or forgetting to submit them to add_path,
or assigning them costs that are high enough to get them rejected?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: check_strxfrm_bug()
Next
From: Michael Paquier
Date:
Subject: Re: check_strxfrm_bug()