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

Re: Adding and filling new column on big table

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Jonathan Blitz <jb(at)anykey(dot)co(dot)il>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Adding and filling new column on big table
Date: 2006-05-30 20:52:32
Message-ID: cone.1149022352.760750.71610.5001@35st-server.simplicato.com (view raw or flat)
Thread:
Lists: pgsql-performance
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). 


In response to

pgsql-performance by date

Next:From: Jonathan BlitzDate: 2006-05-30 21:04:48
Subject: Re: Adding and filling new column on big table
Previous:From: wmiroDate: 2006-05-30 20:47:47
Subject: INSERT OR UPDATE WITHOUT SELECT

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