Re: postgres_fdw prefers fast plans

2025-12-10 Thread Alexander Pyhalov
Laurenz Albe писал(а) 2025-12-10 16:12: On Wed, 2025-12-10 at 15:44 +0300, Alexander Pyhalov wrote: There's a long-standing issue with postgres_fdw - as it uses cursors, it prefers plans, optimized for fetching first rows. In bad scenarios this leads to suboptimal choice of join methods (e.g. c

Re: postgres_fdw prefers fast plans

2025-12-10 Thread Laurenz Albe
On Wed, 2025-12-10 at 15:44 +0300, Alexander Pyhalov wrote: > There's a long-standing issue with postgres_fdw - as it uses cursors, it > prefers plans, optimized for fetching first rows. In bad scenarios this > leads to suboptimal choice of join methods (e.g. choosing nest loop over > hash join)