Thanks for your reply.
---> You should update to a more current minor release. Recently I updated to 9.1.5. I will do in near future. --> You need to provide more information on how you backed up, how you are restoring, and what the bottleneck seems to be. I am pg_restore using for restoring the backup which created using pg_dump. Thanks in Advance Regards Ramana On Mon, Oct 7, 2013 at 10:43 PM, Kevin Grittner <kgri...@ymail.com> wrote: > 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 >
