Large update operations and performance

From: "Jon Asher" <jon(at)vagabond-software(dot)com>
To: <pgsql-general-owner(at)postgresql(dot)org>
Subject: Large update operations and performance
Date: 2004-09-30 05:35:11
Message-ID: 20040930053516.F2600329FDE@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running some very large table update operations (on 2 mil + records) and
the queries are taking 5 + hours to complete. Is there a way to turn off
row-level index updates or something else to make it run more quickly?

Jon

Browse pgsql-general by date

  From Date Subject
Next Message Mike Morris 2004-09-30 06:34:16 psql slow disconnect via ssl
Previous Message Ed L. 2004-09-30 05:23:52 Re: 7.3.4 vacuum/analyze error