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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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