Improve Postgres Query Speed

From: "carter ck" <carterck32(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Improve Postgres Query Speed
Date: 2007-01-16 00:44:57
Message-ID: BAY101-F34720C120DDCA4FD6D178FD5B40@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I am having slow performance issue when querying a table that contains more
than 10000 records.

Everything just slow down when executing a query though I have created Index
on it.

Can anyone suggest ways to improve the speed?

Thanks.

_________________________________________________________________
Find just what you are after with the more precise, more powerful new MSN
Search. http://search.msn.com.sg/ Try it now.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Godoy 2007-01-16 00:52:08 Linking tables and indexes
Previous Message Kevin Field 2007-01-16 00:42:07 Re: Transaction callback