Re: join pushdown and issue with foreign update
От
Tom Lane
Тема
Re: join pushdown and issue with foreign update
Дата
Msg-id
2845636.1622571541@sss.pgh.pa.us
Ответ на
Re: join pushdown and issue with foreign update (Alexander Pyhalov)
Список
Дерево обсуждения
join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Amit Langote <amitlangote09@gmail.com>
Re: join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Tom Lane <tgl@sss.pgh.pa.us>
Re: join pushdown and issue with foreign update Tom Lane <tgl@sss.pgh.pa.us>
Re: join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Amit Langote <amitlangote09@gmail.com>
Re: join pushdown and issue with foreign update Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Re: join pushdown and issue with foreign update Amit Langote <amitlangote09@gmail.com>
Re: join pushdown and issue with foreign update Tom Lane <tgl@sss.pgh.pa.us>
Re: join pushdown and issue with foreign update Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Re: join pushdown and issue with foreign update Tom Lane <tgl@sss.pgh.pa.us>
Alexander Pyhalov writes: > What about the following patch? ISTM that using a specific rowtype rather than RECORD would be quite disastrous from the standpoint of bloating the number of distinct resjunk columns we need for a partition tree with a lot of children. Maybe we'll have to go that way, but it seems like an absolute last resort. I think a preferable fix involves making sure that the correct record-type typmod is propagated to record_in in this context. Alternatively, maybe we could insert the foreign table's rowtype during execution of the input operation, without touching the plan as such. Could we start by creating a test case that doesn't involve uncommittable hacks to the source code? regards, tom lane
В списке pgsql-hackers по дате отправления