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
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.
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
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