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 92A4652A63 for ; Thu, 3 Mar 2005 16:38:40 +0000 (GMT) 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 21832-08 for ; Thu, 3 Mar 2005 16:38:35 +0000 (GMT) Received: from penguin.goodinassociates.com (penguin.goodinassociates.com [206.80.71.229]) by svr1.postgresql.org (Postfix) with ESMTP id 51D2C5521B for ; Thu, 3 Mar 2005 16:38:33 +0000 (GMT) Received: from [206.80.71.242] ([206.80.71.242]) by penguin.goodinassociates.com (8.12.11/8.12.11) with ESMTP id j23GcT2A006940 for ; Thu, 3 Mar 2005 10:38:29 -0600 Subject: name search query speed From: Jeremiah Jahn To: postgres performance Content-Type: text/plain Date: Thu, 03 Mar 2005 10:38:29 -0600 Message-Id: <1109867909.16326.58.camel@bluejay.goodinassociates.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 (2.0.4-1) Content-Transfer-Encoding: 7bit X-RAVMilter-Version: 8.4.4(snapshot 20030410) (penguin.goodinassociates.com) Received-SPF: none (penguin.goodinassociates.com: 206.80.71.242 is neither permitted nor denied by domain of cs.earlham.edu) client-ip=206.80.71.242; envelope-from=jeremiah@cs.earlham.edu; helo=[206.80.71.242]; X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/54 X-Sequence-Number: 10759 I have about 5M names stored on my DB. Currently the searches are very quick unless, they are on a very common last name ie. SMITH. The Index is always used, but I still hit 10-20 seconds on a SMITH or Jones search, and I average about 6 searches a second and max out at about 30/s. Any suggestions on how I could arrange things to make this search quicker? I have 4gb of mem on a raid 5 w/ 3 drives. I'm hoping that I can increase this speed w/o a HW upgrade. thanx, -jj- -- You probably wouldn't worry about what people think of you if you could know how seldom they do. -- Olin Miller.