Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5A5E89FA3A5 for ; Fri, 26 Oct 2007 23:30:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 57138-07 for ; Fri, 26 Oct 2007 23:30:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id C2BE99FA36B for ; Fri, 26 Oct 2007 23:30:28 -0300 (ADT) Received: from scratch (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l9R2UUH1005586; Fri, 26 Oct 2007 19:30:30 -0700 Date: Fri, 26 Oct 2007 19:31:11 -0700 From: "Joshua D. Drake" To: Gregory Stark Cc: "Campbell\, Lance" , Subject: Re: Suggestions on an update query Message-ID: <20071026193111.7a595247@scratch> In-Reply-To: <87odel1feo.fsf@oxford.xeocode.com> References: <20071026141547.70c9c1e0@scratch> <87odel1feo.fsf@oxford.xeocode.com> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.0.2 (GTK+ 2.12.0; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/=9.wwtYwrwf8gAGhYxkadpT"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Virus-Scanned: ClamAV 0.91.1/4598/Thu Oct 25 23:52:26 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 26 Oct 2007 19:30:31 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/315 X-Sequence-Number: 27337 --Sig_/=9.wwtYwrwf8gAGhYxkadpT Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Sat, 27 Oct 2007 03:04:47 +0100 Gregory Stark wrote: > > O.k. first you might be grinding through your 20 checkpoint segments > > but in reality what I think is happening is you are doing foreign > > key checks against all of it and slowing things down. >=20 > If you're going to berate someone about top-posting perhaps you > should attach your own commentary to relevant bits of context :P It was hardly berating Greg, I even said please. > I > suspect you've guessed it right though. In fact I suspect what's > happening is he doesn't have an index on the referencing column so > the foreign key checks are doing sequential scans of. >=20 Sincerely, Joshua D. Drake --=20 =3D=3D=3D The PostgreSQL Company: Command Prompt, Inc. =3D=3D=3D Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ --Sig_/=9.wwtYwrwf8gAGhYxkadpT Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHIqLyATb/zqfZUUQRAoDCAJ9gqo50Ck0kx5PNE0LlAbEh6BT28wCdG17p TznzpE+C53GMbUHdrpCoZs0= =YQhY -----END PGP SIGNATURE----- --Sig_/=9.wwtYwrwf8gAGhYxkadpT--