Indexing + performance

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

Browse pgsql-admin by date

  From Date Subject
Next Message EOsorio 2008-03-05 11:41:52 unuscribe
Previous Message 高崎保行 2008-03-05 08:15:31 Postgres encryption export.