Thread

Re: Query Performance Degradation Due to Partition Scan Order – PostgreSQL v17.6

Andrei Lepikhov <lepihov@gmail.com> — 2025-09-09T07:02:01Z

On 8/9/2025 12:32, Adrien Nayrat wrote:
> On 9/8/25 12:05 PM, Andrei Lepikhov wrote:
>> On 8/9/2025 11:47, Ashutosh Bapat wrote:
>>> On Mon, Sep 8, 2025 at 4:01 AM Vivek Gadge <vvkgadge56@gmail.com> wrote:
> It reminds me of these threads :
Yes, partially. Actively using foreign tables and touching cheaper 
partitions first is crucial in queries with limits. Also, some cases may 
provide an implicit limit, like a merge join.

-- 
regards, Andrei Lepikhov