Re: update performance 8.1.4

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Thomas Markus" <t(dot)markus(at)proventis(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: update performance 8.1.4
Date: 2008-01-15 15:21:52
Message-ID: dcc563d10801150721k53044b50l63bd2ce68c5c48f1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

2008/1/15 Thomas Markus <t(dot)markus(at)proventis(dot)net>:
> Hi,
>
> How can I speed up updates?
> i try an
> update tablename set datecol=null
> ~ 2.3 mio rows

Got any foreign keys against that table? If so, they need to be
indexed on the other end.

What's the schema of that table and any related tables?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Marc Pigeon 2008-01-15 15:32:27 Postgresql 8.2 AUTOVACUUM LOG
Previous Message Scott Marlowe 2008-01-15 15:19:46 Re: Pg_statio_user_tables view does not get populated