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 <[EMAIL PROTECTED]> 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
