update on a large table - Mailing list pgsql-sql

From Aaron Held
Subject update on a large table
Date
Msg-id 1633.66.108.80.175.1029013291.squirrel@metrony.com
Whole thread Raw
In response to Re: Table Sorting and Limit Question  (Dawn Hollingsworth <dmh@airdefense.net>)
List 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




pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: getting ILIKE or ~* to use indexes....
Next
From:
Date:
Subject: Re: getting ILIKE or ~* to use indexes....