Index Maintenance and Reindexing in Postgres

i agree and i but i also echo what you said and i see it brought up most commonly when it comes to query performance. Yeah there's lots of good reasons and i'm glad that they have net positives there as well. There are also of course some downsides in terms of query performance like we see for example the planner has to do some partition pruning right. It can be done with partitioning these like index maintenance vacuum and partitioning these three components should be should play together this is why i put it on the first place i think it's underestimated reason not.