Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 86267634B89 for ; Wed, 25 Feb 2009 17:24:34 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42062-07 for ; Wed, 25 Feb 2009 17:24:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f173.google.com (mail-ew0-f173.google.com [209.85.219.173]) by mail.postgresql.org (Postfix) with ESMTP id 8DB206345BD for ; Wed, 25 Feb 2009 17:24:26 -0400 (AST) Received: by ewy21 with SMTP id 21so424541ewy.19 for ; Wed, 25 Feb 2009 13:24:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :content-type:content-transfer-encoding; bh=CQq49613aTl9qz9bLX0Z+7I9Y8ai9T69J+PImPopE2M=; b=K/lsqqVzzVKA5eggIwV3XPuP25LNUC8PSnm3NgsbAciJM/Nj/hmFKOpDbk5cE+5T2Z JmXsw1Zkl0wWIR7dlS0hPdML86I4fovQImM+WIp/f6WPRopJ3LiwnKDjbkwywJ1GIBHv 1BkWWn9ZLrKBMtijtWSoot9oradVIlbxmGw4o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:content-type:content-transfer-encoding; b=qQD8Vx70i4M7EhUWK+UBr/fqhBHZ84ZnDh2J0DJKMOzRdiRmPha37d0Oz4deTI/1gG jQcDChVFFJdThlQ3dYJ0zCZb10NMPpxDs/3W4yKOZGdQouc52khMIRJ5mdmukODxryRH WnZDFc0grgb7xkAYPU3EW1rNGMdJ7/PuAn4CI= Received: by 10.210.88.3 with SMTP id l3mr279542ebb.46.1235597064684; Wed, 25 Feb 2009 13:24:24 -0800 (PST) Received: from ?192.168.1.102? (62-61-39-029.static.hnet.pl [62.61.39.29]) by mx.google.com with ESMTPS id 7sm1523713eyg.47.2009.02.25.13.24.23 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 25 Feb 2009 13:24:23 -0800 (PST) Message-ID: <49A5B703.7080700@gmail.com> Date: Wed, 25 Feb 2009 22:24:19 +0100 From: Andrzej Zawadzki User-Agent: Icedove 2.0.0.19 (X11/20090101) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: "like" and index References: <8f750b7c0902250259w6065515as350aca3b5d7d8173@mail.gmail.com> <49A553B8.2040009@djs-consulting.com> In-Reply-To: <49A553B8.2040009@djs-consulting.com> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/215 X-Sequence-Number: 31436 Daniel J. Summers wrote: > Tony Liao wrote: >> I try to explain analyze,but it doesn't work ,it use seq scan. > Generally speaking, LIKE doesn't use indexes. ?! That's not true at all!! -- Andrzej Zawadzki