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 6850B52997 for ; Wed, 8 Jun 2005 11:51:15 -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 49010-05 for ; Wed, 8 Jun 2005 14:51:12 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199]) by svr1.postgresql.org (Postfix) with ESMTP id C90BB529A3 for ; Wed, 8 Jun 2005 11:51:06 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 69so280489wra for ; Wed, 08 Jun 2005 07:51:12 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=T3W2jIQduPq3Sk/YlRNNR8913JNat3wCzltXcwQU9UhDRRv58f7nzfd0g/KOLUk7TggYBv95uOMLpwrlvQxmPqSKhe+Umn9IGHGemPzC5IfBNZpT5SuG3+tMOadZBUfe5jOJ+O1dqoKPqulL6S7q1w1rWCOXPeDSx7qe0TmSEJo= Received: by 10.54.15.75 with SMTP id 75mr3392739wro; Wed, 08 Jun 2005 07:51:11 -0700 (PDT) Received: by 10.54.96.18 with HTTP; Wed, 8 Jun 2005 07:51:11 -0700 (PDT) Message-ID: <6744b385050608075132eeb8a6@mail.gmail.com> Date: Wed, 8 Jun 2005 09:51:11 -0500 From: George Essig Reply-To: George Essig To: K C Lau Subject: Re: SELECT DISTINCT Performance Issue Cc: pgsql-performance@postgresql.org In-Reply-To: <6.2.1.2.0.20050608221510.02c4e368@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <6.2.1.2.0.20050602190756.05ab2c70@localhost> <6744b38505060806342e6a07d@mail.gmail.com> <6.2.1.2.0.20050608221510.02c4e368@localhost> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.086 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/171 X-Sequence-Number: 12808 On 6/8/05, K C Lau wrote: > Both keys are text fields. Does it make any difference if PlayerID were > integer? >=20 It can make a difference in speed and integrity. If the column is an integer, the storage on disk could be smaller for the column and the related indexes. If the the column is an integer, it would not be possible to have a value like 'arbitrary value that looks nothing like an integer'. George Essig