Обсуждение: Re: [HACKERS] VACUUM as a denial-of-service attack

Поиск
Список
Период
Сортировка

Re: [HACKERS] VACUUM as a denial-of-service attack

От
Keith Parks
Дата:
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.