Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group