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

update performance 8.1.4

From: Thomas Markus <t(dot)markus(at)proventis(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: update performance 8.1.4
Date: 2008-01-15 09:33:32
Message-ID: 478C7DEC.1020806@proventis.net (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

How can I speed up updates?
i try an
  update tablename set datecol=null
~ 2.3 mio rows

After 6 hours, this was still not finished. selects and inserts are ok.
System is a dual xeon, 8gb ram, debian 64bit, pg 8.1.4

thanks
thomas






-- 
Thomas Markus

Tel:    +49 30 29 36 399 - 22
Fax:    +49 30 29 36 399 - 50
Mail:   t(dot)markus(at)proventis(dot)net
Web:    http://www.proventis.net
Web:    http://www.blue-ant.de

proventis GmbH
Zimmerstraße 79-80
10117 Berlin

Geschäftsführer: Norman Frischmuth
Sitz: Berlin
Handelsregister: AG Berlin-Charlottenburg, HR 82917

We support your project business!


Attachment: t_markus.vcf
Description: text/x-vcard (255 bytes)

Responses

pgsql-admin by date

Next:From: Sebastian ReitenbachDate: 2008-01-15 09:44:28
Subject: backup WAL files,
Previous:From: Tom LaneDate: 2008-01-15 02:02:04
Subject: Re: current_query column of pg_stat_activity view

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