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