Re: Allowing ALTER TYPE to change storage strategy
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2020-03-05T23:08:27Z
Lists: pgsql-hackers
Tomas Vondra <tomas.vondra@2ndquadrant.com> writes: > Yeah, I agree #1 seems like the cleanest/best option. Are you worried > about the overhead due to the extra complexity, or overhead due to > cache getting invalidated for this particular reason? The overhead is basically a hash_seq_search traversal over the typcache each time we get a pg_type inval event, which there could be a lot of. On the other hand we have a lot of inval overhead already, so this might not amount to anything noticeable. regards, tom lane
Commits
-
Allow ALTER TYPE to change some properties of a base type.
- fe30e7ebfa38 13.0 landed