> On Sat, Feb 12, 2022 at 2:35 AM Robert Haas <robertmh...@gmail.com> wrote: >> >> >> Imagine that I am using the "foo" tableam with "compression=lots" and >> I want to switch to the "bar" AM which does not support that option. >> If I remove the "compression=lots" option using a separate command, >> the "foo" table AM may rewrite my whole table and decompress >> everything. Then when I convert to the "bar" AM it's going to have to >> be rewritten again. That's painful. I clearly need some way to switch >> AMs without having to rewrite the table twice. > Agreed. Better to avoid multiple rewrites here. Thank you for figuring out this.
> You'd need to be able to do multiple things with one command e.g. > ALTER TABLE mytab SET ACCESS METHOD baz RESET compression, SET > preferred_fruit = 'banana'; +1 Silently dropping some options is not right and it may confuse users too. So I would like to go for the command you have suggested, where the user should be able to SET & RESET multiple options in a single command for an object. Thanks & Regards SadhuPrasad http://www.enterprisedb.com
