X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7C10D528D0 for ; Wed, 1 Jun 2005 06:45:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35465-06 for ; Wed, 1 Jun 2005 09:45:06 +0000 (GMT) Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id 08C0F528B2 for ; Wed, 1 Jun 2005 06:45:05 -0300 (ADT) Received: (qmail 4135 invoked by uid 0); 1 Jun 2005 09:45:06 -0000 Received: from 217.17.202.254 by www18.gmx.net with HTTP; Wed, 1 Jun 2005 11:45:06 +0200 (MEST) Date: Wed, 1 Jun 2005 11:45:06 +0200 (MEST) From: "Marc Mamin" To: pgsql-performance@postgresql.org MIME-Version: 1.0 References: <1117616779.3844.903.camel@localhost.localdomain> Subject: TIP 9: the planner will ignore... & datatypes X-Priority: 3 (Normal) X-Authenticated: #3793498 Message-ID: <29804.1117619106@www18.gmx.net> X-Mailer: WWW-Mail 1.6 (Global Message Exchange) X-Flags: 0001 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.033 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/10 X-Sequence-Number: 12648 TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match But INT2, INT4, INT8 and "SERIAL" are considered to be a unique datatype. Am I Right? Thanks, Marc -- Geschenkt: 3 Monate GMX ProMail gratis + 3 Ausgaben stern gratis ++ Jetzt anmelden & testen ++ http://www.gmx.net/de/go/promail ++