From: Aaron Held <aaron@metrony.com>
To: pgsql-sql@postgresql.org
Subject: update on a large table
Date: Sat, 10 Aug 2002 21:01:31 -0000 (GMT)
Message-ID: <1633.66.108.80.175.1029013291.squirrel@metrony.com> (raw)
In-Reply-To: <1028901334.1423.18.camel@kaos>
References: <1028901334.1423.18.camel@kaos>
I need to do an UPDATE on a large (100 million record) table. Is there
any way to speed up the process (Like turning off the transaction log)?
So far postgres has been handling the large database exceptionally well
(large \copy imports and WHERE clauses w/ multiple params) but it is
killing me on UPDATES. It takes about 4 hours to run an UPDATE (the WHERE
clause is against an INDEX) but about 50 sec for a similar SELECT.
Thank You,
-Aaron Held
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-sql@postgresql.org
Cc: aaron@metrony.com
Subject: Re: update on a large table
In-Reply-To: <1633.66.108.80.175.1029013291.squirrel@metrony.com>
* 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