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 17:25:35
Message-ID: cone.1149009935.943516.71610.5001@35st-server.simplicato.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.


In response to

Responses

pgsql-performance by date

Next:From: WaldomiroDate: 2006-05-30 18:29:49
Subject: INSERT OU UPDATE WITHOUT SELECT?
Previous:From: mcelroy, timDate: 2006-05-30 17:12:33
Subject: Re: pg_dump issue

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