From: Francisco Reyes <lists@stringsutils.com>
To: Jonathan Blitz <jb@anykey.co.il>
Cc: pgsql-performance@postgresql.org
Subject: Re: Adding and filling new column on big table
Date: Tue, 30 May 2006 16:52:32 -0400
Message-ID: <cone.1149022352.760750.71610.5001@35st-server.simplicato.com> (raw)
References: <012501c6842c$bb8438f0$ddf71005@jonathanlaptop>
Jonathan Blitz writes:
> I suppose I could do but I need to install PostgreSQL there and then copy
> over the database.
> Maybe I will give it a try.
I really think that is your best bet.
If for whatever reason that will not be an option perhaps you can just let
the process run over the weekend.. possibly monitor the process from the OS
to make sure it is not frozen.
Don't recall if you mentioned the OS.. is it any unix like os?
If so there are several ways you could check to make sure the process is not
frozen such as iostats, top, vmstats(these from FreeBSD, but most unix like
os should have tools like those if not some with the same name).
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: lists@stringsutils.com, jb@anykey.co.il
Subject: Re: Adding and filling new column on big table
In-Reply-To: <cone.1149022352.760750.71610.5001@35st-server.simplicato.com>
* 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