ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> Now, I want to ask you how to modify WITH parameters for existing
> tables/indexes.
I'd go with the ALTER TABLE, rather than cluttering N other commands.
There's already precedent for delayed effects of parameter alterations
(SET, ALTER SET STATISTICS, ALTER SET STORAGE, etc). Documenting which
commands cause the new values to take effect seems sufficient.
regards, tom lane