X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D0AD0475CE5 for ; Fri, 28 Feb 2003 20:22:46 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 21562-06 for ; Fri, 28 Feb 2003 20:22:45 -0500 (EST) Received: from xeon.unixathome.org (bast.unixathome.org [66.11.174.150]) by postgresql.org (Postfix) with ESMTP id 68F08475E24 for ; Fri, 28 Feb 2003 20:12:52 -0500 (EST) Received: by xeon.unixathome.org (Postfix, from userid 1000) id 37E023F4A; Fri, 28 Feb 2003 20:12:48 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by xeon.unixathome.org (Postfix) with ESMTP id 294D93F49; Fri, 28 Feb 2003 20:12:48 -0500 (EST) Date: Fri, 28 Feb 2003 20:12:48 -0500 (EST) From: Dan Langille X-X-Sender: dan@xeon.unixathome.org To: "Montrone, Marc -- 7183" Cc: "'pgsql-sql@postgresql.org'" Subject: Re: Optimizing In-Reply-To: <6F92EBF93563D411A42200508BD97A9A05645C2A@KCNT02B> Message-ID: <20030228201127.M54500@xeon.unixathome.org> References: <6F92EBF93563D411A42200508BD97A9A05645C2A@KCNT02B> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/639 X-Sequence-Number: 12037 On Fri, 28 Feb 2003, Montrone, Marc -- 7183 wrote: > Please advise how I can improve performance of query searching for telephone > numbers. I have a table with over a million records of phone numbers in a > single indexed field. To find one phone number takes nearly 20 seconds. > Aside from hardware upgrades, how can I improve the performance of this > query? Thank you in advance. Please provide the following which will help us to help you: The output of this commend : select version(); Please prefix your query with "explain analyze" and provide us with both the query and the output of this command.