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