Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Adding and filling new column on big table
- From: PFC <lists(at)peufeu(dot)com>
- To: "Jonathan Blitz" <jb(at)anykey(dot)co(dot)il>, "'Francisco Reyes'" <lists(at)stringsutils(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Adding and filling new column on big table
- Date: Tue, 30 May 2006 22:24:32 +0200
Most laptop drives are only 5,400 RPM which would make a transaction likeyou 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.
- References:
- Re: Adding and filling new column on big table
- From: Jonathan Blitz
- Re: Adding and filling new column on big table
- Prev by Date: Re: Adding and filling new column on big table
- Next by Date: Re: Adding and filling new column on big table
- Previous by thread: Re: Adding and filling new column on big table
- Next by thread: Re: Adding and filling new column on big table
- Indexes: