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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: a lot of shared buffers hit when planning for a simple query with primary access path
From: David Rowley <dgrowleyml@xxxxxxxxx>
Date: Mon, 1 Jul 2024 22:52:03 +1200
Cc: James Pang <jamespang886@xxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAFj8pRAkhf3_T3vpga0K9C_fPgZe9QsFsgqDW2HtwSrkFbTP+A@mail.gmail.com>
References: <CAHgTRfdDye2G=Kb53h4a23Hf-n7_ygHwQgbV9B4HKLCkykohpA@mail.gmail.com> <CAApHDvoR17=B42zHe_QtPgcQdpHic5+nz8V0VqvbRsNxo3V5Zw@mail.gmail.com> <CAFj8pRAkhf3_T3vpga0K9C_fPgZe9QsFsgqDW2HtwSrkFbTP+A@mail.gmail.com>

On Mon, 1 Jul 2024 at 22:20, Pavel Stehule <pavel.stehule@xxxxxxxxx> 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

Follow-Ups:
- Re: a lot of shared buffers hit when planning for a simple query with primary access path
  - From: James Pang

References:
- a lot of shared buffers hit when planning for a simple query with primary access path
  - From: James Pang
- Re: a lot of shared buffers hit when planning for a simple query with primary access path
  - From: David Rowley
- Re: a lot of shared buffers hit when planning for a simple query with primary access path
  - From: Pavel Stehule

Prev by Date: Re: a lot of shared buffers hit when planning for a simple query with primary access path
Next by Date: Re: a lot of shared buffers hit when planning for a simple query with primary access path
Previous by thread: Re: a lot of shared buffers hit when planning for a simple query with primary access path
Next by thread: Re: a lot of shared buffers hit when planning for a simple query with primary access path
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]