Re: [GENERAL] 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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general