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 E10E154D6F for ; Thu, 3 Mar 2005 17:00:14 +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 31994-02 for ; Thu, 3 Mar 2005 16:59:56 +0000 (GMT) Received: from fep2.cogeco.net (smtp.cogeco.net [216.221.81.25]) by svr1.postgresql.org (Postfix) with ESMTP id 58D2B5514D for ; Thu, 3 Mar 2005 16:59:54 +0000 (GMT) Received: from windsortransportationclub.com (d57-59-156.home.cgocable.net [24.57.59.156]) by fep2.cogeco.net (Postfix) with SMTP id A205F309D for ; Thu, 3 Mar 2005 11:59:53 -0500 (EST) Received: (qmail 14384 invoked from network); 3 Mar 2005 17:30:56 -0000 Received: from d36-80-110.home1.cgocable.net (HELO KEN) (24.36.80.110) by 0 with SMTP; 3 Mar 2005 17:30:56 -0000 Message-ID: <000601c52012$70808c20$6a01a8c0@KEN> From: "Ken Egervari" To: "Jeremiah Jahn" , References: <1109867909.16326.58.camel@bluejay.goodinassociates.com> Subject: Re: name search query speed Date: Thu, 3 Mar 2005 12:00:01 -0500 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.778 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL, RCVD_IN_SORBS_DUL X-Spam-Level: * X-Archive-Number: 200503/55 X-Sequence-Number: 10760 I'm not sure what the answer is but maybe I can help? Would clustering the name index make this faster? I thought that would bunch up the pages so the names were more or less in order, which would improve search time. Just a guess though. Ken ----- Original Message ----- From: "Jeremiah Jahn" To: "postgres performance" Sent: Thursday, March 03, 2005 11:38 AM Subject: [PERFORM] name search query speed >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. > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >