Re: update performance 8.1.4 - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: update performance 8.1.4
Date
Msg-id dcc563d10801150721k53044b50l63bd2ce68c5c48f1@mail.gmail.com
Whole thread Raw
In response to update performance 8.1.4  (Thomas Markus <t.markus@proventis.net>)
List pgsql-admin
2008/1/15 Thomas Markus <t.markus@proventis.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?

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Pg_statio_user_tables view does not get populated
Next
From: Jean-Marc Pigeon
Date:
Subject: Postgresql 8.2 AUTOVACUUM LOG