Re: [HACKERS] VACUUM as a denial-of-service attack
Keith Parks <emkxp01@mtcc.demon.co.uk>
From: Keith Parks <emkxp01@mtcc.demon.co.uk>
To: tgl@sss.pgh.pa.us
Cc: pgsql-hackers@postgresql.org
Date: 1999-11-29T19:30:51Z
Lists: pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> > >Keith Parks <emkxp01@mtcc.demon.co.uk> writes: >> In the dim and distant past I produced a patch that put vacuum >> into the list of things that you could GRANT on a per-table > >Thanks for the code, but for now I just threw in a quick pg_ownercheck >call: VACUUM will now vacuum all tables if you are the superuser, else >just the tables you own, skipping the rest with a NOTICE. What you had >looked like more infrastructure than I thought the problem was worth... >I suspect most people will run VACUUMs from the superuser account >anyway... I didn't think it was worth reworking the code, although I may do just for fun. Your solution is fine. Keith.