Reg. Restore

[Venakata Ramana <ramana.pls@xxxxxxxxx>]

Hi,

I am using postgresql 9.1.5. on windows Xp. 

I am facing two problems: 

1. Restore of DB is very slow.

    How to improve the speed of Restore?

2. Without indexes, retrieving from table is fast?

    After creating an index on that table, then the retrieval become slow.

plz prove any solution

Thanks in advance

Regards

Ramana