I was surprised to see that while I was updating a single column value for all records in a tables, all indexes are locked by the server.
On Tue, Sep 11, 2012 at 7:44 PM, hubert depesz lubaczewski <depesz@depesz.com> wrote:
On Tue, Sep 11, 2012 at 07:20:28PM +0600, AI Rumman wrote: > I have a table as follows:
> I execued the query: > ALTER TABLE entity ADD COLUMN owner_type char(1) NOT NULL default 'U'; > > The db is stuck. The enity table has 2064740 records;
such alter table has to rewrite whole table. So it will take a while
> Watching locks:
output of this was perfectly unreadable, because your email client wrapped lines at some random places.
In future - please put such dumps on some paste site, or just attach it to mail, and not copy/paste them to body of message.
Best regards,
depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/