Postgres Pro
Downloads
Home   >   mailing lists

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

From Jonathan Blitz
Subject Re: Adding and filling new column on big table
Date
Msg-id 012501c6842c$bb8438f0$ddf71005@jonathanlaptop
Whole thread Raw
In response to Re: Adding and filling new column on big table  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: Adding and filling new column on big table  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Adding and filling new column on big table  (PFC <lists@peufeu.com>)
List pgsql-performance
Tree view 
>
> Most laptop drives are only 5,400 RPM which would make a transaction like
> you are describing likely take a while.

Not sure what my one is but it is new(ish).

>
> No desktop at home you could try it on?
> I think the problem with the laptop is likely it's drive.

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.

Jonathan

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.4/351 - Release Date: 05/29/2006

pgsql-performance by date:

Previous
From: "Daniel J. Luke"
Date:
Subject: Re: Getting even more insert performance (250m+rows/day)
Next
From: Scott Marlowe
Date:
Subject: Re: Adding and filling new column on big table