update on a large table

From: "Aaron Held" <aaron(at)metrony(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: update on a large table
Date: 2002-08-10 21:01:31
Message-ID: 1633.66.108.80.175.1029013291.squirrel@metrony.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message mallah 2002-08-10 21:14:17 Re: getting ILIKE or ~* to use indexes....
Previous Message Josh Berkus 2002-08-10 18:10:16 Re: getting ILIKE or ~* to use indexes....