Postgres Pro
Downloads
Home   >   mailing lists

ALTER TABLE ADD COLUMN Hangs - Mailing list pgsql-admin

From Samuel Stearns
Subject ALTER TABLE ADD COLUMN Hangs
Date
Msg-id 68B59BEDCD36854AADBDF17E91B2937A01A4DC6236@EXCHMAIL.staff.internode.com.au
Whole thread Raw
Responses Re: ALTER TABLE ADD COLUMN Hangs  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Re: ALTER TABLE ADD COLUMN Hangs  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: ALTER TABLE ADD COLUMN Hangs  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
Tree view

Howdy,

 

I’m running in an 8.3.3 environment.  What could cause, or how can I diagnose, why an ‘ALTER TABLE <name> ADD COLUMN’ statement runs for hours eventually locking users out and requiring to be killed in the end?

 

Thanks,

 

Sam

pgsql-admin by date:

Previous
From: Bryan White
Date:
Subject: Re: pg_restore -j
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: ALTER TABLE ADD COLUMN Hangs