Skip site navigation (1) Skip section navigation (2)

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: 2006-05-30 09:35:55
Message-ID: 005701c683cc$7757af00$ddf71005@jonathanlaptop (view raw or flat)
Thread:
Lists: pgsql-performance
> > 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
 


In response to

Responses

pgsql-performance by date

Next:From: Alvis TunkelisDate: 2006-05-30 13:05:53
Subject: Re: Selects query stats?
Previous:From: Francisco ReyesDate: 2006-05-30 03:52:35
Subject: Re: Selects query stats?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group