X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 0AB9D11F6C2F for ; Tue, 18 Apr 2006 12:16:36 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.599 X-Spam-Level: X-Spam-Status: No, score=-2.599 required=5 tests=[BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id SgXiAIKxXtd0 for ; Tue, 18 Apr 2006 12:16:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mediaskill.de (destiny.mediaskill.de [212.91.236.1]) by postgresql.org (Postfix) with ESMTP id 928B911F6295 for ; Tue, 18 Apr 2006 12:16:23 -0300 (ADT) Received: from localhost ([127.0.0.1]) by mail.mediaskill.de (Merak 8.3.8) with SMTP id WTI26620; Tue, 18 Apr 2006 17:16:20 +0200 Date: Tue, 18 Apr 2006 17:16:18 +0200 From: "Tarabas (Manuel Rorarius)" X-Mailer: The Bat! (v3.62.14) Professional Reply-To: "Tarabas (Manuel Rorarius)" Organization: mediaskill X-Priority: 3 (Normal) Message-ID: <1043488152.20060418171618@tarabas.de> To: "Dave Dutcher" , pgsql-performance@postgresql.org Subject: Re: Problem with LIKE-Performance In-Reply-To: <001a01c662f9$f2449f00$8300a8c0@tridecap.com> References: <341367953.20060418163513@tarabas.de> <001a01c662f9$f2449f00$8300a8c0@tridecap.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200604/374 X-Sequence-Number: 18458 Hi Dave, DD> It looks like you are getting a sequential scan instead of an index DD> scan. What is your locale setting? As far as I know Postgres doesn't DD> support using indexes with LIKE unless you are using the C locale. Actually no, I am using de_DE as locale because I need the german order-by support. But even for a seq-scan it seems pretty slow, but that's just a feeling. The table currently has ~172.000 rows and is suposed to rise to about 1 mio or more. Is there any way to speed the like's up with a different locale than C or to get an order by in a different Locale although using the default C locale? DD> Also, in the future you only need to post EXPLAIN ANALYZE not EXPLAIN DD> ANALYZE VERBOSE. ok, i will keep that in mind :-) didn't know how verbose you would need it *smile* Best regards Manuel