Re: Reg. Restore

Поиск
Список
Период
Сортировка
От Venakata Ramana
Тема Re: Reg. Restore
Дата
Msg-id CACiDZ3XSecTtMY49EDXnk1=4BcLfMXAGbAakQeWOsGYaw9x2Ag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reg. Restore  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Venakata Ramana
Дата:
Сообщение: Re: Reg. Restore
Следующее
От: reiner peterke
Дата:
Сообщение: Re: uuid extension not available