Skip site navigation (1) Skip section navigation (2)

Re: Adding and filling new column on big table

From: "Jonathan Blitz" <jb(at)anykey(dot)co(dot)il>
To: "'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: 2006-05-30 17:11:30
Message-ID: 00d201c6840c$2543eb80$ddf71005@jonathanlaptop (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
> Could you do the updates in batches instead of trying to do them all at
> once?

Nope. Didn't think it would make any difference.
> Have you done a vacuum full on this table ever?

Many times

> What hardware?
> I have a dual CPU opteron with 4GB of RAM and 8 disks in RAID 10 (SATA).
> Doing an update on a 5 million record table took quite a while, but it did
> fininish. :-)

I am using a laptop :).
Pentium 4 (not 4M) with 1GB of memory - 2 MHZ

Must do it on  that since the program is aimed for use at home.


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

In response to


pgsql-performance by date

Next:From: mcelroy, timDate: 2006-05-30 17:12:33
Subject: Re: pg_dump issue
Previous:From: Tom LaneDate: 2006-05-30 16:20:23
Subject: Re: pg_dump issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group