[pgpool-general: 9173] Re: How does process_management_mode=dynamic decide which idle connections to drop?

[Ron Johnson]

On Thu, Jul 18, 2024 at 1:13 AM Bo Peng <pengbo at sraoss.co.jp> wrote:

> hi,
>
> > Postgresql 14.12
> >
> > $ pgpool --version
> > pgpool-II version 4.5.2 (hotooriboshi)
> >
> > $ psql -p9999 -c "pgpool show all;" | grep -E
> > 'process_management|spare_children' | cut -c1-55
> >  process_management_strategy                | gentle
> >  process_management_mode                    | dynamic
> >  min_spare_children                         | 5
> >  max_spare_children                         | 10
> >
> > Attached is a text file showing two queries against pg_stat_activity,
> about
> > 20 minutes apart.
> > The oldest idle connections (pids 1244035 through 1244035 in the text
> file)
> > haven't been dropped, even though they've been idle for more than an
> hour,
> > and other, younger connections were dropped.
> >
> > I'd have expected an LRU algorithm, but apparently not.
>
> Do you mean the spare processes kill algorithm to satisfy
> max_spare_children?
>

Correct.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240718/5578496a/attachment.htm>