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
Thanks for your reply.
---> You should update to 9.1.9.
Recently I updated to 9.1.5. I will do in near future.
--> How are you doing this restore? Is it from a dump? Are you using or
could you use custom format?
I am pg_restore using for restoring the backup which created using pg_dump.
-
On Tue, Oct 8, 2013 at 2:43 AM, Venakata Ramana wrote:
> Thanks for your reply.
>
>
> ---> You should update to 9.1.9.
>
> Recently I updated to 9.1.5. I will do in near future.
>
>
Recently??? 9.1.5 was released more then one year ago... =/
>
> --> How are you doing this restore? Is it from a du
Venakata Ramana 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 bac
On Mon, Oct 7, 2013 at 9:03 AM, Venakata Ramana wrote:
> Hi,
>
> I am using postgresql 9.1.5. on windows Xp.
>
>
You should update to 9.1.9.
I am facing two problems:
>
> 1. Restore of DB is very slow.
> How to improve the speed of Restore?
>
>
How are you doing this restore? Is it from a du
Hi,
I am using postgresql 9.1.5. on windows Xp.
I am facing two problems:
1. Restore of DB is very slow.
How to improve the speed of Restore?
2. Without indexes, retrieving from table is fast?
After creating an index on that table, then the retrieval become slow.
plz prove any solution
