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 D2EAD9FA5E9 for ; Tue, 30 May 2006 14:25:46 -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 88708-01 for ; Tue, 30 May 2006 14:25: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 CCAA59FADD1 for ; Tue, 30 May 2006 14:25:40 -0300 (ADT) Received: from localhost (localhost.natserv.net [127.0.0.1]) by zoraida.natserv.net (Postfix) with SMTP id AADE2B81F for ; Tue, 30 May 2006 13:25:39 -0400 (EDT) Received: from zoraida.natserv.net (localhost.natserv.net [127.0.0.1]) by zoraida.natserv.net (Postfix) with ESMTP id 0A06CB822; Tue, 30 May 2006 13:25:37 -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 85AB7B81F; Tue, 30 May 2006 13:25:36 -0400 (EDT) References: <00d201c6840c$2543eb80$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 13:25:35 -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 13:25:39 2006 X-DSPAM-Confidence: 0.9899 X-DSPAM-Probability: 0.0000 X-DSPAM-Signature: 58,447c8013348147593317928 X-DSPAM-Factors: 27, Date*May, 0.01000, Content-Type*charset="US, 0.01000, Received*ESMTP, 0.01000, Received*ESMTP, 0.01000, Content-Disposition*inline, 0.01000, Content-Type*ASCII", 0.01000, Cc*pgsql, 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, Received*May, 0.01000, Received*May, 0.01000, Received*with, 0.01000, Received*with, 0.01000, X-Mailer*mta.org/cone/, 0.01000, Received*id, 0.01000, Received*id, 0.01000, Received*ESMTP+id, 0.01000, Received*ESMTP+id, 0.01000, Content-Type*charset="US+ASCII", 0.01000, X-Mailer*http, 0.01000, From*Francisco+Reyes, 0.01000, Cc*performance, 0.01000, Received*from+zoraida.natserv.net, 0.01000, Date*0400, 0.01000 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/532 X-Sequence-Number: 19319 Jonathan Blitz writes: > Nope. Didn't think it would make any difference. May be worth a try. > I am using a laptop :). > Pentium 4 (not 4M) with 1GB of memory - 2 MHZ Most laptop drives are only 5,400 RPM which would make a transaction like you are describing likely take a while. > Must do it on that since the program is aimed for use at home. No desktop at home you could try it on? I think the problem with the laptop is likely it's drive.