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: 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: Tue, 30 May 2006 13:25:35 -0400
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.
- Follow-Ups:
- Re: Adding and filling new column on big table
- From: Jonathan Blitz
- Re: Adding and filling new column on big table
- 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: pg_dump issue
- Next by Date: INSERT OU UPDATE WITHOUT SELECT?
- 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: