Re: Improve Postgres Query Speed

Поиск
Список
Период
Сортировка
От Chad Wagner
Тема Re: Improve Postgres Query Speed
Дата
Msg-id 81961ff50701151654s2eed1548wfbd8097dbf01a424@mail.gmail.com
обсуждение исходный текст
Ответ на Improve Postgres Query Speed  ("carter ck" <carterck32@hotmail.com>)
Ответы Re: Improve Postgres Query Speed  ("carter ck" <carterck32@hotmail.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: "carter ck"
Дата:
Сообщение: Improve Postgres Query Speed
Следующее
От: Jorge Godoy
Дата:
Сообщение: Linking tables and indexes