Search Postgresql Archives

Re: indexing - creates problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> I am having a table with more than 1000 records, i am not having index in
> that, while executing that query it occupies the processor..

1000 rows is not much - I guess the index is not necessary at all, as the
traditional sequential scan is faster than index scan (due to random
access vs. sequential access).

But you have not provided enough information, so we can't give you precise
answer. You should answer at least these questions:

0) What version of postgresql (and on what OS) are you running? What
machine is it running on?

1) What is the structure of the table? What columns does have, etc. Post
the CREATE script, or a similar description.

2) What query are you executing? Post the query as well as an explain plan
for it (EXPLAIN command before the SELECT).

3) Have you analyzed the table before executing the query? Have you
vacuumed the table recently?

Tomas



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux