Venakata Ramana <ramana....@gmail.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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
