Re: Adding and filling new column on big table - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: Adding and filling new column on big table
Date
Msg-id cone.1149009935.943516.71610.5001@35st-server.simplicato.com
Whole thread Raw
In response to Re: Adding and filling new column on big table  ("Jonathan Blitz" <jb@anykey.co.il>)
Responses Re: Adding and filling new column on big table  ("Jonathan Blitz" <jb@anykey.co.il>)
List 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.


pgsql-performance by date:

Previous
From: "mcelroy, tim"
Date:
Subject: Re: pg_dump issue
Next
From: "Daniel J. Luke"
Date:
Subject: Re: Getting even more insert performance (250m+rows/day)