On 2019-07-08 21:08, Julien Rouhaud wrote: > Don't get me wrong, I do agree that implementing filtering in the > backend is a better design. What's bothering me is that I also agree > that there will be more glibc breakage, and if that happens within a > few years, a lot of people will still be using pg12- version, and they > still won't have an efficient way to rebuild their indexes. Now, it'd > be easy to publish an external tools that does a simple > parallel-and-glic-filtering reindex tool that will serve that purpose > for the few years it'll be needed, so everyone can be happy.
You can already do that: Run a query through psql to get a list of affected tables or indexes and feed those to reindexdb using -i or -t options. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
