Re: name search query speed
От | Ken Egervari |
---|---|
Тема | Re: name search query speed |
Дата | |
Msg-id | 000601c52012$70808c20$6a01a8c0@KEN обсуждение исходный текст |
Ответ на | name search query speed (Jeremiah Jahn <jeremiah@cs.earlham.edu>) |
Ответы |
Re: name search query speed
|
Список | pgsql-performance |
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" <jeremiah@cs.earlham.edu> To: "postgres performance" <pgsql-performance@postgresql.org> 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 >
В списке pgsql-performance по дате отправления: