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

Hi

po 1. 7. 2024 v 12:10 odesílatel David Rowley <dgrowleyml(at)gmail(dot)com> napsal:

> On Mon, 1 Jul 2024 at 21:45, James Pang <jamespang886(at)gmail(dot)com> wrote:
> > Buffers: shared hit=110246 <<< here planning need access a
> lot of buffers
> > Planning Time: 81.850 ms
> > Execution Time: 0.034 ms
> >
> > could you help why planning need a lot of shared buffers access ?
>
> Perhaps you have lots of bloat in your system catalogue tables. That
> could happen if you make heavy use of temporary tables. There are many
> other reasons too. It's maybe worth doing some vacuum work on the
> catalogue tables.
>

The planners get min/max range from indexes. So some user's indexes can be
bloated too with similar effect

Regards

Pavel

> David
>
>
>