On 2024-11-01 09:25:24, David Rowley <dgrowleyml(at)gmail(dot)com> wrote: > We have the ability to store immutable defaults in the catalogue tables and > "fill in the blanks" from there for any tuples that don't have the new > column. Since we only can store 1 value per column, it must be a constant, > i.e. the same for all rows.
Thanks for clarifying that David. Profiling can be deceiving if you don't have experience in the code base. > If timing isn't confirmation enough, try doing the above with: SET > client_min_messages=debug1; > > Only adding column "d" gives you: DEBUG: rewriting table "t1" Oh wow, that's a very useful setting to have, thanks for pointing that out too. Best, Marcelo
