Re: How much size saved by updating column to NULL ?

2024-01-12 Thread Tom Lane
Ron Johnson writes: > On Fri, Jan 12, 2024 at 7:45 AM Sébastien TANIERE > wrote: >> Do we save 8 bytes by timestamp column updated to NULL or not ? > I don't think the record on the page is rewritten in a more compact form. > Even if it were, the page would just have a small hole in it. > A

Re: How much size saved by updating column to NULL ?

2024-01-12 Thread Ron Johnson
On Fri, Jan 12, 2024 at 7:45 AM Sébastien TANIERE wrote: > Hello, > in my company, some columns rarely used in a PG database 14.8 have been > set to NULL in order to save disk space (datecreation & acteurcreation in > following table) . > > create table example > ( > id

Re: How much size saved by updating column to NULL ?

2024-01-12 Thread David G. Johnston
On Friday, January 12, 2024, Sébastien TANIERE wrote: > Hello, > in my company, some columns rarely used in a PG database 14.8 have been > set to NULL in order to save disk space (datecreation & acteurcreation in > following table) . > > create table example > ( > id