X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 99829D1D1A4 for ; Wed, 18 Feb 2004 22:53:23 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 23927-09 for ; Wed, 18 Feb 2004 18:53:23 -0400 (AST) Received: from smtp811.mail.sc5.yahoo.com (smtp811.mail.sc5.yahoo.com [66.163.170.81]) by svr1.postgresql.org (Postfix) with SMTP id AB24FD1E0F4 for ; Wed, 18 Feb 2004 18:53:19 -0400 (AST) Received: from unknown (HELO ANDYXP) (drlaz@sbcglobal.net@64.160.53.113 with login) by smtp811.mail.sc5.yahoo.com with SMTP; 18 Feb 2004 22:52:18 -0000 Message-ID: <0a0c01c3f671$ceb08c80$847ba8c0@ANDYXP> From: "Andrew Lazarus" To: Subject: JOIN order, 15K, 15K, 7MM rows Date: Wed, 18 Feb 2004 14:51:52 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0A09_01C3F62E.BE85BCB0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_MESSAGE, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200402/245 X-Sequence-Number: 5769 This is a multi-part message in MIME format. ------=_NextPart_000_0A09_01C3F62E.BE85BCB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable All three tables have the same integer key, and it's indexed. I parenthesized the joins to do the two small tables first. I'm running and INSERT INTO ... SELECT query with this join (one record add= ed per record in join), 4 hours down and all I have to show for it is 100 r= ecycled transaction logs. ? If it ever returns, I can post the Explain output. ------=_NextPart_000_0A09_01C3F62E.BE85BCB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
All three tables have the same int= eger key,=20 and it's indexed.
 
I parenthesized the joins to do th= e two=20 small tables first.
 
I'm running and INSERT INTO ... SE= LECT=20 query with this join (one record added per record in join), 4 hours down an= d all=20 I have to show for it is 100 recycled transaction logs. ?
 
If it ever returns, I can post the= Explain=20 output.
------=_NextPart_000_0A09_01C3F62E.BE85BCB0--