Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Adding and filling new column on big table
- From: "Jonathan Blitz" <jb(at)anykey(dot)co(dot)il>
- To: "'Francisco Reyes'" <lists(at)stringsutils(dot)com>
- Cc: <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: Adding and filling new column on big table
- Date: Tue, 30 May 2006 11:35:55 +0200
> > So, I have tried to run the following command. The command never finishes > > (I gave up after about and hour and a half!). > > Did you ever find what was the problem? > Perhaps you needed to run a vacuum full on the table? Nope. I just gave up in the end and left it with NULL as the default value. There were, in fact, over 2 million rows in the table rather than 1/4 of a million so that was part of the problem. Jonathan -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.7.4/351 - Release Date: 05/29/2006
- Follow-Ups:
- Re: Adding and filling new column on big table
- From: Francisco Reyes
- Re: Adding and filling new column on big table
- References:
- Re: Adding and filling new column on big table
- From: Francisco Reyes
- Re: Adding and filling new column on big table
- Prev by Date: Re: Selects query stats?
- Next by Date: Re: Selects query stats?
- Previous by thread: Re: Adding and filling new column on big table
- Next by thread: Re: Adding and filling new column on big table
- Indexes: