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: (view raw, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group