From: | "petchimuthu lingam" <spmlingam(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Indexing + performance |
Date: | 2008-03-05 09:57:26 |
Message-ID: | cd233fc30803050157w4e0a8b3x47b87c7e497d6ade@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear Friends,
I have a table with 50 lakhs records, the table has more then 10
fields, i have primary key, i have select query with count(*) without any
condition, it takes 17 seconds.
I have another one query which will do joins with other small tables, it
takes 47 seconds to give output, the result has 2 lakhs records. the
indexing is not used. I have created one index with one field ( which i
used in this query, the field value has duplicates also ).
Now the cpu usage is 4.4%, and waiting for io process .
i have checked the above in the top command.
If i delete that index, then it works fine, now the cpu usage takes more
then 70%, and waiting shows less then 30%.
Can Anyone explain, Why postgres behaves like this.
Thanks....
--
With Best Regards,
Petchimuthulingam S
From | Date | Subject | |
---|---|---|---|
Next Message | EOsorio | 2008-03-05 11:41:52 | unuscribe |
Previous Message | 高崎保行 | 2008-03-05 08:15:31 | Postgres encryption export. |