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.
In response to
- Optimizing at 2003-02-28 15:26:08 from Montrone, Marc -- 7183
pgsql-sql by date
|Next:||From: Steve Crawford||Date: 2003-03-01 01:16:42|
|Subject: Re: Optimizing|
|Previous:||From: Dmitry Tkach||Date: 2003-02-28 22:47:04|
|Subject: Re: DELETE FROM t WHERE EXISTS|