Re: bytea encode performance issues

I ran the update, but now (obviously) it wants to vacuum again and
vacuum on that table took 9 hours yesterday.

Do the statistics change when changing the storage type? Meaning does it
really need to vacuum?

Thank you
Sim

Tom Lane wrote:
> Sim Zacks <sim@compulab.co.il> writes:
>> After the alter table, then I have to update each row with an
>> update dbmail_messageblks set messageblk=messageblk;
>> so that it uses the new storage.
>
> I wouldn't actually bet on that changing anything at all ...
> I'd try something like messageblk = messageblk || '' to make
> completely sure the value gets detoasted.
>
>             regards, tom lane