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 DBBF455478 for ; Thu, 3 Mar 2005 17:23:59 +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 37292-09 for ; Thu, 3 Mar 2005 17:23:54 +0000 (GMT) Received: from penguin.goodinassociates.com (penguin.goodinassociates.com [206.80.71.229]) by svr1.postgresql.org (Postfix) with ESMTP id F0E6C566CD for ; Thu, 3 Mar 2005 17:23:37 +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 j23HNbEt007660; Thu, 3 Mar 2005 11:23:37 -0600 Subject: Re: name search query speed From: Jeremiah Jahn To: Ken Egervari Cc: pgsql-performance@postgresql.org In-Reply-To: <000601c52012$70808c20$6a01a8c0@KEN> References: <1109867909.16326.58.camel@bluejay.goodinassociates.com> <000601c52012$70808c20$6a01a8c0@KEN> Content-Type: text/plain Date: Thu, 03 Mar 2005 11:23:37 -0600 Message-Id: <1109870617.16326.63.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/56 X-Sequence-Number: 10761 yes, it does. I forgot to mention, that I also have clustering on that table by my name_field index. My Bad. On Thu, 2005-03-03 at 12:00 -0500, Ken Egervari wrote: > 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 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- You probably wouldn't worry about what people think of you if you could know how seldom they do. -- Olin Miller.