From: Jonathan Blitz <jb@anykey.co.il>
To: 'Francisco Reyes' <lists@stringsutils.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Adding and filling new column on big table
Date: Tue, 30 May 2006 19:11:30 +0200
Message-ID: <00d201c6840c$2543eb80$ddf71005@jonathanlaptop> (raw)
In-Reply-To: <cone.1149004718.536638.48418.1000@zoraida.natserv.net>
>
>
> 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.
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jb@anykey.co.il, lists@stringsutils.com
Subject: Re: Adding and filling new column on big table
In-Reply-To: <00d201c6840c$2543eb80$ddf71005@jonathanlaptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox