Postgres Pro
Downloads
Home   >   mailing lists

Re: Reg. Restore - Mailing list pgsql-admin

From Venakata Ramana
Subject Re: Reg. Restore
Date
Msg-id CACiDZ3XSecTtMY49EDXnk1=4BcLfMXAGbAakQeWOsGYaw9x2Ag@mail.gmail.com
Whole thread Raw
In response to Re: Reg. Restore  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-admin
Tree view
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 <kgrittn@ymail.com> wrote:
Venakata Ramana <ramana.pls@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

pgsql-admin by date:

Previous
From: Venakata Ramana
Date:
Subject: Re: Reg. Restore
Next
From: reiner peterke
Date:
Subject: Re: uuid extension not available