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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance sfpug

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

Browse pgsql-admin by date

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

Browse pgsql-performance by date

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

Browse sfpug by date

  From Date Subject
Next Message Reece Hart 2003-07-23 18:07:10 Re: [PERFORM] slow table updates
Previous Message Richard Huxton 2003-07-23 08:49:09 Re: slow table updates