Re: Improve Postgres Query Speed

From: "Chad Wagner" <chad(dot)wagner(at)gmail(dot)com>
To: "carter ck" <carterck32(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Improve Postgres Query Speed
Date: 2007-01-16 00:54:51
Message-ID: 81961ff50701151654s2eed1548wfbd8097dbf01a424@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 1/15/07, carter ck <carterck32(at)hotmail(dot)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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message carter ck 2007-01-16 01:08:19 Re: Improve Postgres Query Speed
Previous Message Jorge Godoy 2007-01-16 00:52:08 Linking tables and indexes