ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>> So I gave up waiting for someone else to do the reloptions patch for
>> autovacuum and started work on it myself.
> Is it needed to keep backward compatibility?
> I'd like to suggest to keep pg_catalog.pg_autovacuum as a system view
> even after the options is put into reloptons, and the view to be
> updatable using RULEs if possible.
Ugh. No. It has been explicitly stated all along that pg_autovacuum
was a temporary API and that anyone depending on it could expect future
trouble.
> But we will not able to do that if the settings will be in reloptions
> because ALTER TABLE SET cannot be used with JOINs.
Any mechanism that a rule might use to set reloptions would be just
as usable in a join as the rule itself ...
regards, tom lane