Re: Poor performance with row wise comparisons

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Jon Emord <jon(at)peregrine(dot)io>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Poor performance with row wise comparisons
Date: 2025-02-07 14:43:14
Message-ID: CAKAnmmJDHajWWYx8bMUJRxVHZnLnP0WhEMZD40jeqrZ7aLsFUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Feb 7, 2025 at 2:05 AM Jon Emord <jon(at)peregrine(dot)io> wrote:

> but with limit 101, the extra shared hits return
>

Can you show the explain analyze for the limit 101 case?

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

In response to

Browse pgsql-performance by date

  From Date Subject
Previous Message jian he 2025-02-07 13:14:09 Re: Re: proposal: schema variables