On Fri, Jun 7, 2019 at 2:35 PM Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> wrote: > I envision this happening automatically -- you drop the partition, a > persistent work item is registered, autovacuum takes care of it > whenever. The user doesn't have to do anything about it. We don't have to agree on anything now, but I think that it's possible that the page split thing will very effective. Perhaps even so effective that it won't make much sense to vacuum global indexes just because there is a pending dropped partition. -- Peter Geoghegan