Postgres Pro
Downloads
Home   >   mailing lists

Re: Poor performance with row wise comparisons - Mailing list pgsql-performance

From Greg Sabino Mullane
Subject Re: Poor performance with row wise comparisons
Date
Msg-id CAKAnmmJDHajWWYx8bMUJRxVHZnLnP0WhEMZD40jeqrZ7aLsFUw@mail.gmail.com
Whole thread Raw
In response to Poor performance with row wise comparisons  (Jon Emord <jon@peregrine.io>)
List pgsql-performance
Tree view
On Fri, Feb 7, 2025 at 2:05 AM Jon Emord <jon@peregrine.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

pgsql-performance by date:

Previous
From: Jon Emord
Date:
Subject: Poor performance with row wise comparisons
Next
From: kyle Hailey
Date:
Subject: Re: lwlock:LockManager wait_events