Noah Misch <noah(at)leadboat(dot)com> writes:
>>>> That helps, but we'd probably want to do something more general about vacuumdb
>>>> and schema USAGE permission.
I agree a more general fix is needed, but I think excluding temp
tables as suggested is a good idea for performance, independently of
permissions concerns. vacuum_rel() will ignore requests to vacuum
such tables, which is why we've not heard complaints before, but
nonetheless we're wasting server round trips by issuing those
requests.
regards, tom lane