I stopped the query this morning after 24 hours of running, restarted
pgadmin and restarted the postgresql server.
I ran the query again and it went relatively quickly (only 1.3 hours).
I don't know what went wrong, but apparently something did.
Sim
Sim Zacks wrote:
> I am running a query in PG
I am running a query in PGAdmin.
I changed the storage on a bytea field from External to Main and then ran
update dbmail_messageblks set messageblk=messageblk || '';
so that it would move all the rows to the new storage.
This is a very large table, so I actually expect it to take a long tim
