| From: | Dan Langille <dan(at)langille(dot)org> |
|---|---|
| To: | "Montrone, Marc -- 7183" <marc(dot)montrone(at)novastar1(dot)com> |
| Cc: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Optimizing |
| Date: | 2003-03-01 01:12:48 |
| Message-ID: | 20030228201127.M54500@xeon.unixathome.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, 28 Feb 2003, Montrone, Marc -- 7183 wrote:
> Please advise how I can improve performance of query searching for telephone
> numbers. I have a table with over a million records of phone numbers in a
> single indexed field. To find one phone number takes nearly 20 seconds.
> Aside from hardware upgrades, how can I improve the performance of this
> query? Thank you in advance.
Please provide the following which will help us to help you:
The output of this commend : select version();
Please prefix your query with "explain analyze" and provide us with both
the query and the output of this command.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2003-03-01 01:16:42 | Re: Optimizing |
| Previous Message | Dmitry Tkach | 2003-02-28 22:47:04 | Re: DELETE FROM t WHERE EXISTS |