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

Re: [PERFORM] slow table updates

From: Reece Hart <rkh(at)gene(dot)COM>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>,"pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>,SF PostgreSQL <sfpug(at)postgresql(dot)org>
Subject: Re: [PERFORM] slow table updates
Date: 2003-07-23 17:44:36
Message-ID: 1058982275.7281.83.camel@tallac (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performancesfpug
Richard-

Thanks for the suggestions. I too had thought about the FK checks, even
though the columns aren't getting updated.

I'm flabbergasted that the update is still running (~22 hours elapsed).
By comparison, the database takes only 4 hours to recreate from backup!
Something funny is happening here. I just interrupted the update and
will find another way.

But hang on, what's this:

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
30164 compbio   25   0  6056 6056  3568 R    98.8  0.1  29:55 postgres: admin csb [local] COPY


I am the only user and I'm not doing a copy... this must be part of the
update process. Does anyone out there know whether updates do a table
copy instead of in-table udpating (perhaps as a special case for
whole-table updates)?

Of course, I can't help but wonder whether I just killed it when it was
nearly done...

Thanks,
Reece


-- 
Reece Hart, Ph.D.                       rkh(at)gene(dot)com, http://www.gene.com/
Genentech, Inc.                         650/225-6133 (voice), -5389 (fax)
Bioinformatics and Protein Engineering
1 DNA Way, MS-93                        http://www.in-machina.com/~reece/
South San Francisco, CA  94080-4990     reece(at)in-machina(dot)com, GPG: 0x25EC91A0

In response to

pgsql-admin by date

Next:From: Bruce MomjianDate: 2003-07-23 17:54:15
Subject: Re: using ssl some of the time
Previous:From: scott.marloweDate: 2003-07-23 15:41:12
Subject: Re: Using the /var/lib/pgsql/data directory in the absense

sfpug by date

Next:From: Reece HartDate: 2003-07-23 18:07:10
Subject: Re: [PERFORM] slow table updates
Previous:From: Richard HuxtonDate: 2003-07-23 08:49:09
Subject: Re: slow table updates

pgsql-performance by date

Next:From: Reece HartDate: 2003-07-23 18:07:10
Subject: Re: [PERFORM] slow table updates
Previous:From: mallahDate: 2003-07-23 17:21:16
Subject: Re: factoring problem with view in 7.3.3 [ SOLVED ]

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