Ayush Vatsa <ayushvatsa1...@gmail.com> writes: >> As it stands, a superuser can prewarm an index (because she bypasses all >> privilege checks including this one), but nobody else can.
> That's not fully true. Any role can prewarm an index if the role has the > correct privileges. Ah, right. An index will have null pg_class.relacl, which'll be interpreted as "owner has all rights", so it will work for the table owner too. Likely this explains the lack of prior complaints. It's still a poor design IMO. regards, tom lane