From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org, Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
Subject: | Re: Move pg_attribute.attcompression to earlier in struct for reduced size? |
Date: | 2021-05-26 19:31:28 |
Message-ID: | 1556957.1622057488@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Wed, May 26, 2021 at 11:13 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> * As things stand here, once you've applied ALTER ... SET COMPRESSION
>> to select a specific method, there is no way to undo that and go
>> back to the use-the-default setting. All you can do is change to
>> explicitly select the other method. Should we invent "ALTER ...
>> SET COMPRESSION default" or the like to cover that?
> Yes. Irreversible catalog changes are bad.
Here's an add-on 0004 that does that, and takes care of assorted
silliness in the grammar and docs --- did you know that this patch
caused
alter table foo alter column bar set ;
to be allowed?
I think this is about ready to commit now (though I didn't yet nuke
GetDefaultToastCompression).
regards, tom lane
Attachment | Content-Type | Size |
---|---|---|
0004-allow-set-compression-default.patch | text/x-diff | 29.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2021-05-26 19:32:38 | Re: Move pg_attribute.attcompression to earlier in struct for reduced size? |
Previous Message | Stephen Frost | 2021-05-26 18:37:05 | Re: storing an explicit nonce |