Re: Reg. Restore

Venakata Ramana <ramana(dot)pls(at)gmail(dot)com> wrote:

> I am using postgresql 9.1.5. on windows Xp.

You should update to a more current minor release.

http://www.postgresql.org/support/versioning/

> 1. Restore of DB is very slow.
>     How to improve the speed of Restore?

You need to provide more information on how you backed up, how you
are restoring, and what the bottleneck seems to be.

http://www.postgresql.org/docs/9.1/interactive/backup.html

> 2. Without indexes, retrieving from table is fast?
>     After creating an index on that table, then the retrieval
>     become slow.

There's not enough information to give much advice.  Please read
this page and start a new thread on the pgsql-performance list:

http://wiki.postgresql.org/wiki/SlowQueryQuestions

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company