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

From PFC
Subject Re: Adding and filling new column on big table
Date
Msg-id op.tadsa6vmcigqcu@apollo13
Whole thread Raw
In response to Re: Adding and filling new column on big table  ("Jonathan Blitz" <jb@anykey.co.il>)
List pgsql-performance
>> 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).

    If you're doing data intensive operations (like a big update which looks
like what you're doing) it will write many megabytes to the harddrive...
my laptop HDD (5400 rpm) does about 15 MB/s throughput while a standard
desktop 7200rpm drive does 55-60 MB/s throughput. Plus, seek times on a
laptop drive are horrendous.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Adding and filling new column on big table
Next
From: Francisco Reyes
Date:
Subject: Re: Adding and filling new column on big table