Re: effects of nullifying bytea column on storage

2022-05-12 Thread Hugh Ranalli
On Wed, 11 May 2022 at 20:02, David Gauthier wrote: > 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

Re: effects of nullifying bytea column on storage

2022-05-11 Thread David G. Johnston
On Wednesday, May 11, 2022, David Gauthier wrote: > Doesn't vacuum run automatically (or can it be set to run automatically) ? > > https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM David J.

Re: effects of nullifying bytea column on storage

2022-05-11 Thread David Gauthier
Doesn't vacuum run automatically (or can it be set to run automatically) ? On Wed, May 11, 2022 at 8:05 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, May 11, 2022, David Gauthier wrote: > >> Hi: >> psql (11.5, server 11.3) on linux >> >> I have a table with a bytea c

Re: effects of nullifying bytea column on storage

2022-05-11 Thread David G. Johnston
On Wednesday, May 11, 2022, David Gauthier wrote: > 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 u