Re: [ADMIN] ALTER TABLE ADD COLUMN Hangs

2010-04-21 Thread Scott Marlowe
On Wed, Apr 21, 2010 at 8:17 PM, Samuel Stearns wrote: > Howdy, > > I’m running in an 8.3.3 environment.  What could cause, or how can I > diagnose, why an ‘ALTER TABLE ADD COLUMN’ statement runs for hours > eventually locking users out and requiring to be killed in the end? And not that it matt

Re: [ADMIN] ALTER TABLE ADD COLUMN Hangs

2010-04-21 Thread Scott Marlowe
On Wed, Apr 21, 2010 at 8:17 PM, Samuel Stearns wrote: > Howdy, > > I’m running in an 8.3.3 environment.  What could cause, or how can I > diagnose, why an ‘ALTER TABLE ADD COLUMN’ statement runs for hours > eventually locking users out and requiring to be killed in the end? By any chance you go

Re: [ADMIN] ALTER TABLE ADD COLUMN Hangs

2010-04-21 Thread Ross J. Reedstrom
On Thu, Apr 22, 2010 at 11:47:34AM +0930, Samuel Stearns wrote: > Howdy, > > I'm running in an 8.3.3 environment. What could cause, or how can I > diagnose, why an 'ALTER TABLE ADD COLUMN' statement runs for hours > eventually locking users out and requiring to be killed in the end? > ALTER

[ADMIN] ALTER TABLE ADD COLUMN Hangs

2010-04-21 Thread Samuel Stearns
Howdy, I'm running in an 8.3.3 environment. What could cause, or how can I diagnose, why an 'ALTER TABLE ADD COLUMN' statement runs for hours eventually locking users out and requiring to be killed in the end? Thanks, Sam

Re: [ADMIN] pg_restore -j

2010-04-21 Thread Bryan White
On Tue, Apr 20, 2010 at 11:32 AM, Tom Lane wrote: > There was something similar reported here: > http://archives.postgresql.org/pgsql-admin/2010-04/msg00237.php > but we haven't got to the bottom of it yet. That issue turned out to be me not paying attention to the pg_dump output. There was a de