Postgres Pro
Downloads
Home   >   mailing lists

Re: Allowing REINDEX to have an optional name - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: Allowing REINDEX to have an optional name
Date
Msg-id 20220628001807.GF19662@telsasoft.com
Whole thread Raw
In response to Re: Allowing REINDEX to have an optional name  (Simon Riggs <simon.riggs@enterprisedb.com>)
List pgsql-hackers
Tree view 
Maybe the answer is to 1) add a parenthesized option REINDEX(SYSTEM) (to allow
the current behavior); and 2) make REINDEX DATABASE an alias which implies
"SYSTEM false"; 3) prohibit REINDEX (SYSTEM true) SYSTEM, or consider removing
"REINDEX SYSTEM;".

That avoids the opaque and surprising behavior that "REINDEX DATABASE" skips
system stuff but "REINDEX DATABASE foo" doesn't, while allowing the old
behavior (disabled by default).

pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: pg_upgrade (12->14) fails on aggregate
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: [BUG] Panic due to incorrect missingContrecPtr after promotion