Re: Size of pg_rewrite (Was: Report checkpoint progress with pg_stat_progress_checkpoint)

2022-04-08 Thread Andres Freund
Hi, On April 8, 2022 7:52:07 AM PDT, Matthias van de Meent wrote: >On Sat, 19 Mar 2022 at 01:15, Andres Freund wrote: >> pg_rewrite without pg_stat_progress_checkpoint: 745472, with: 753664 >> >> pg_rewrite is the second biggest relation in an empty database already... > >Yeah, that's not grea

Re: Size of pg_rewrite

2022-04-08 Thread Matthias van de Meent
On Fri, 8 Apr 2022 at 17:20, Dagfinn Ilmari Mannsåker wrote: > > Matthias van de Meent writes: > > > But, as text literal concatenations don't seem to get constant folded > > before storing them in the rules table, this rewrite of the views > > would result in long lines in the system_views.sql f

Re: Size of pg_rewrite

2022-04-08 Thread Dagfinn Ilmari Mannsåker
Matthias van de Meent writes: > But, as text literal concatenations don't seem to get constant folded > before storing them in the rules table, this rewrite of the views > would result in long lines in the system_views.sql file, or we'd have > to deal with the additional overhead of the append op