X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D0ABE9FAE4E for ; Tue, 30 May 2006 17:52:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 14797-06 for ; Tue, 30 May 2006 17:52:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147]) by postgresql.org (Postfix) with ESMTP id A8B979FA5E9 for ; Tue, 30 May 2006 17:52:41 -0300 (ADT) Received: from localhost (localhost.natserv.net [127.0.0.1]) by zoraida.natserv.net (Postfix) with SMTP id AE65CB81F for ; Tue, 30 May 2006 16:52:36 -0400 (EDT) Received: from zoraida.natserv.net (localhost.natserv.net [127.0.0.1]) by zoraida.natserv.net (Postfix) with ESMTP id C372BB822; Tue, 30 May 2006 16:52:33 -0400 (EDT) Received: from 35st-server.simplicato.com (static-71-249-233-130.nycmny.east.verizon.net [71.249.233.130]) by zoraida.natserv.net (Postfix) with ESMTP id 4ECB0B81F; Tue, 30 May 2006 16:52:33 -0400 (EDT) References: <012501c6842c$bb8438f0$ddf71005@jonathanlaptop> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Jonathan Blitz Cc: pgsql-performance@postgresql.org Subject: Re: Adding and filling new column on big table Date: Tue, 30 May 2006 16:52:32 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP X-DSPAM-Result: Innocent X-DSPAM-Processed: Tue May 30 16:52:36 2006 X-DSPAM-Confidence: 0.9899 X-DSPAM-Probability: 0.0000 X-DSPAM-Signature: 58,447cb094348141809116389 X-DSPAM-Factors: 27, writes+>, 0.01000, Date*May, 0.01000, To*anykey.co.il>, 0.01000, Subject*on+big, 0.01000, Content-Type*charset="US, 0.01000, Received*ESMTP, 0.01000, Received*ESMTP, 0.01000, Content-Disposition*inline, 0.01000, Jonathan+Blitz, 0.01000, Subject*new+column, 0.01000, writes, 0.01000, Subject*filling, 0.01000, Subject*column+on, 0.01000, Subject*[PERFORM]+Adding, 0.01000, Content-Type*ASCII", 0.01000, Blitz, 0.01000, that, 0.01000, that, 0.01000, Cc*pgsql, 0.01000, Subject*table, 0.01000, Received*zoraida.natserv.net, 0.01000, Received*zoraida.natserv.net, 0.01000, Received*May+2006, 0.01000, Received*May+2006, 0.01000, Date*May+2006, 0.01000, Subject*big+table, 0.01000, Received*May, 0.01000 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/537 X-Sequence-Number: 19324 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).