effects of nullifying bytea column on storage - Mailing list pgsql-general

From David Gauthier
Subject effects of nullifying bytea column on storage
Date
Msg-id CAEs=6DmeNC1iWyALHgzFytUdphj8GvLxwB1D6XS6yoiKp6eJ9w@mail.gmail.com
Whole thread Raw
Responses Re: effects of nullifying bytea column on storage
Re: effects of nullifying bytea column on storage
List pgsql-general
Hi:
psql (11.5, server 11.3) on linux

I have a table with a bytea column which, of course, contains binary data.  After 60 days, I no longer need the binary data but want to retain the rest of the record.  Of course it's easy to just update the bytea column to null for the older records.  But I can almost imagine this record on disk with a big "hole" in the middle where the bytea data used to be.  Is there a PG daemon (the vacuum ?) that will "heal the hole" in time?

Thanks !


pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: consistent postgresql snapshot
Next
From: "David G. Johnston"
Date:
Subject: Re: effects of nullifying bytea column on storage