| From: | John A Meinel <john(at)arbash-meinel(dot)com> |
|---|---|
| To: | Jeremiah Jahn <jeremiah(at)cs(dot)earlham(dot)edu> |
| Cc: | postgres performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: name search query speed |
| Date: | 2005-03-03 17:46:02 |
| Message-ID: | 42274D5A.1070402@arbash-meinel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Jeremiah Jahn wrote:
>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-
>
>
>
>
>
It sounds like the problem is just that you have a lot of rows that need
to be returned. Can you just put a limit on the query? And then change
the client app to recognize when the limit is reached, and either give a
link to more results, or refine query, or something like that.
John
=:->
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schaber | 2005-03-03 18:36:45 | Re: name search query speed |
| Previous Message | Josh Berkus | 2005-03-03 17:44:37 | Re: name search query speed |