Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX

Julien Rouhaud <rjuju123@gmail.com>

From: Julien Rouhaud <rjuju123@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Shayon Mukherjee <shayonj@gmail.com>, Sami Imseih <samimseih@gmail.com>, Robert Treat <rob@xzilla.net>, David Rowley <dgrowleyml@gmail.com>, jian he <jian.universality@gmail.com>, Gurjeet Singh <gurjeet@singh.im>, Nathan Bossart <nathandbossart@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-08-04T04:52:20Z
Lists: pgsql-hackers
On Mon, 4 Aug 2025, 12:39 Michael Paquier, <michael@paquier.xyz> wrote:

> On Mon, Aug 04, 2025 at 12:34:14PM +0800, Julien Rouhaud wrote:
> > FWIW if anyone actually needs it, that feature had existed for decades in
> > plantuner: http://www.sigaev.ru/git/gitweb.cgi?p=plantuner.git;a=summary


that's weird, I tried from 2 different ISP in Taiwan and both work just
fine, I guess Japan is blocking .ru tld.

>
> Your link does not work here, this one does:
> https://github.com/postgrespro/plantuner


yes although this one doesn't seem maintained anymore, the original repo
does have way more recent commits.

>
> Thanks for mentioning that, so it's a set of GUCs that rely on
> get_relation_info_hook_type for the index filtering.
>

exactly.

>