Postgres Pro
Downloads
Home   >   mailing lists

Re: Improve Postgres Query Speed - Mailing list pgsql-general

From Chad Wagner
Subject Re: Improve Postgres Query Speed
Date
Msg-id 81961ff50701151654s2eed1548wfbd8097dbf01a424@mail.gmail.com
Whole thread Raw
In response to Improve Postgres Query Speed  ("carter ck" <carterck32@hotmail.com>)
Responses Re: Improve Postgres Query Speed
List pgsql-general
Tree view
On 1/15/07, carter ck <carterck32@hotmail.com> wrote:
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.

You didn't really provide much information for anyone to help you.  I would suggest posting the table definition (columns & indexes), the queries you are running, and the output of "EXPLAIN ANALYZE <your query here>;".

--
Chad
http://www.postgresqlforums.com/

pgsql-general by date:

Previous
From: "carter ck"
Date:
Subject: Improve Postgres Query Speed
Next
From: Jorge Godoy
Date:
Subject: Linking tables and indexes