Re: Per-table storage parameters for TableAM/IndexAM extensions - Mailing list pgsql-hackers

From Sadhuprasad Patro
Subject Re: Per-table storage parameters for TableAM/IndexAM extensions
Date
Msg-id CAFF0-CGnjXcd7q-RWht=s7rj_DF3xukZ6xC45dUNunJeB7vTMw@mail.gmail.com
Whole thread Raw
In response to Re: Per-table storage parameters for TableAM/IndexAM extensions  (Dilip Kumar <dilipbalaut@gmail.com>)
Responses Re: Per-table storage parameters for TableAM/IndexAM extensions  (Simon Riggs <simon.riggs@enterprisedb.com>)
List pgsql-hackers
> On Sat, Feb 12, 2022 at 2:35 AM Robert Haas <robertmhaas@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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: CREATEROLE and role ownership hierarchies
Next
From: Robert Haas
Date:
Subject: Re: buildfarm warnings