Skip site navigation (1) Skip section navigation (2)

Re: Optimizing

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 (view raw or flat)
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.

In response to

  • Optimizing at 2003-02-28 15:26:08 from Montrone, Marc -- 7183

pgsql-sql by date

Next:From: Steve CrawfordDate: 2003-03-01 01:16:42
Subject: Re: Optimizing
Previous:From: Dmitry TkachDate: 2003-02-28 22:47:04
Subject: Re: DELETE FROM t WHERE EXISTS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group