Quick Links

ALTER TABLE <name> ADD COLUMN Hangs

From:	Samuel Stearns <SStearns(at)internode(dot)com(dot)au>
To:	"pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject:	ALTER TABLE <name> ADD COLUMN Hangs
Date:	2010-04-22 02:17:34
Message-ID:	68B59BEDCD36854AADBDF17E91B2937A01A4DC6236@EXCHMAIL.staff.internode.com.au
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-admin

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

Responses

Re: ALTER TABLE <name> ADD COLUMN Hangs at 2010-04-22 03:43:17 from Ross J. Reedstrom
Re: ALTER TABLE <name> ADD COLUMN Hangs at 2010-04-22 06:44:27 from Scott Marlowe
Re: ALTER TABLE <name> ADD COLUMN Hangs at 2010-04-22 06:45:07 from Scott Marlowe

Browse pgsql-admin by date

	From	Date	Subject
Next Message	Ross J. Reedstrom	2010-04-22 03:43:17	Re: ALTER TABLE <name> ADD COLUMN Hangs
Previous Message	Bryan White	2010-04-21 09:23:28	Re: pg_restore -j