From: Jonathan Blitz <jb@anykey.co.il>
To: 'Francisco Reyes' <lists@stringsutils.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Adding and filling new column on big table
Date: Tue, 30 May 2006 11:35:55 +0200
Message-ID: <005701c683cc$7757af00$ddf71005@jonathanlaptop> (raw)
In-Reply-To: <cone.1148959356.787773.34675.1000@zoraida.natserv.net>
> > 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jb@anykey.co.il, lists@stringsutils.com
Subject: Re: Adding and filling new column on big table
In-Reply-To: <005701c683cc$7757af00$ddf71005@jonathanlaptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox