Horton

Re: a lot of shared buffers hit when planning for a simple query with primary access path

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: James Pang <jamespang886@gmail.com>, pgsql-performance@lists.postgresql.org
Date: 2024-07-01T10:52:03Z
Lists: pgsql-performance 
On Mon, 1 Jul 2024 at 22:20, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> The planners get min/max range from indexes. So some user's indexes can be bloated too with similar effect

I considered that, but it doesn't apply to this query as there are no
range quals.

David