proposal - log queries where plan was changed due effective_cache_size

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: proposal - log queries where plan was changed due effective_cache_size
Date: 2026-11-05 05:10:03
Message-ID: CAFj8pRB+qif2QFGWhH899MSSCB39LWHwu8xOi=qxnkN_TJ6o2w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

When we set effective_cache_size, we are mostly blind. Maybe we can log
queries where the current setting of effective_cache_size changed the plan.

What do you think?

Regards

Pavel

Browse pgsql-hackers by date

  From Date Subject
Previous Message Xuneng Zhou 2026-11-05 05:07:39 Re: Preferred way to submit a very large batch of bugs?